/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50638
Source Host           : localhost:3306
Source Database       : a_sss

Target Server Type    : MYSQL
Target Server Version : 50638
File Encoding         : 65001

Date: 2018-12-26 09:45:24
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `es_sss_goods_data`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_goods_data`;
CREATE TABLE `es_sss_goods_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `goods_id` int(10) DEFAULT NULL COMMENT '商品id',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `brand_id` int(10) DEFAULT NULL COMMENT '品牌id',
  `category_id` int(10) DEFAULT NULL COMMENT '分类id',
  `category_path` varchar(255) DEFAULT NULL COMMENT '分类路径',
  `seller_id` int(10) DEFAULT NULL COMMENT '商家id',
  `shop_cat_id` int(10) DEFAULT NULL COMMENT '商家分类id',
  `price` decimal(20,2) DEFAULT NULL COMMENT '商品价格',
  `favorite_num` int(10) DEFAULT NULL COMMENT '收藏数量',
  `market_enable` smallint(1) DEFAULT NULL COMMENT '是否上架',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=264 DEFAULT CHARSET=utf8 COMMENT='统计库商品数据(es_sss_goods_data)';

-- ----------------------------
-- Records of es_sss_goods_data
-- ----------------------------
INSERT INTO `es_sss_goods_data` VALUES ('1', '1', '百草味菠萝干100g 菠萝块凤梨干/片蜜饯水果干小吃', '0', '14', '0|1|13|14|', '15', '4', '25.90', '2', '1');
INSERT INTO `es_sss_goods_data` VALUES ('2', '2', '百草味手剥松子128g 坚果炒货干果特产开口手拨瓜子大籽', '0', '2', '0|1|2|', '15', '7', '35.60', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('3', '3', '百草味手剥松子128g 坚果炒货干果特产开口手拨瓜子大籽', '0', '2', '0|1|2|', '15', '7', '12.50', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('4', '4', '良品铺子酸奶果粒块54g草莓蓝莓干水果酸奶块休闲零食特产小吃', '0', '377', '0|1|377|', '15', '6', '195.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('5', '5', '百草味仁仁果750g 每日坚果仁混合果仁30袋干果零食', '0', '2', '0|1|2|', '15', '7', '15.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('6', '6', '良品铺子山楂片250g山楂干山楂圆片零食蜜饯特产食品', '0', '318', '0|4|5|318|', '15', '6', '89.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('7', '8', '百草味冻干榴莲干30g 金枕头榴莲干 休闲零食水果干', '0', '31', '0|4|31|', '15', '7', '29.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('8', '9', '良品铺子猪肉脯自然片100g原味休闲食品猪肉干猪肉铺零食小吃', '0', '326', '0|4|325|326|', '15', '5', '56.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('9', '10', '百草味牛轧奶芙(蔓越莓味)160g 沙琪玛牛萨萨糕点心', '0', '368', '0|4|27|368|', '15', '4', '29.80', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('10', '11', '百草味板栗仁80g 坚果零食特产熟制甘栗仁即食栗子仁', '0', '358', '0|4|358|', '15', '2', '52.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('11', '12', '良品铺子烤香肠145g小香肠零食特产猪肉枣烤肉肠红肠', '0', '36', '0|35|36|', '15', '2', '150.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('12', '13', '百草味麻薯(抹茶味)210g 糕点小吃美食 休闲零食点心', '0', '144', '0|35|144|', '15', '2', '180.99', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('13', '14', '朵趣手造芒果味爆浆麻薯台式手工特产小吃糕点心208g', '0', '153', '0|35|151|153|', '15', '2', '259.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('14', '15', '洋河蓝色经典 海之蓝52度375ml 2瓶 洋河官方旗舰店 绵柔型白酒', '0', '431', '0|35|429|431|', '15', '2', '299.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('15', '16', '熊孩子 综合水果干108gx2袋混合装果干什锦脱水蔬果脆片休闲零食', '0', '164', '0|35|160|164|', '15', '2', '599.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('16', '17', '好时之吻KISSES巧克力500g曲奇味糖果零食婚庆结婚喜糖袋装批发', '0', '40', '0|38|39|40|', '15', '2', '59.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('17', '18', '【憨豆熊 纸皮巴旦木208g*2袋】杏仁坚果零食手剥干果扁桃仁', '0', '48', '0|38|47|48|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('18', '19', '三只松鼠 开心果100g休闲零食每日坚果特产炒货原味无漂白', '0', '54', '0|38|51|54|', '15', '2', '47.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('19', '20', '三只松鼠 夏威夷果265g零食每日坚果特产食品果仁送开口器奶油味', '0', '172', '0|38|171|172|', '15', '2', '25.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('20', '21', '三只松鼠 炭烧腰果90g坚果零食每日坚果特产干果仁', '0', '45', '0|38|43|45|', '15', '7', '59.80', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('21', '22', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '0', '57', '0|56|57|', '16', '13', '25.99', '1', '1');
INSERT INTO `es_sss_goods_data` VALUES ('22', '23', 'PANMAX潮牌大码男装 胖子冬装男衣服羊羔绒宽松加肥加大连帽卫衣', '0', '91', '0|86|91|', '16', '12', '52.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('23', '24', '中长款韩版风衣男潮牌百搭加绒加厚大衣冬季外套2017新款帅气学生', '0', '275', '0|86|91|275|', '16', '12', '79.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('24', '25', '伟臣潮牌大码男装秋冬装毛衣男士加肥加大开叉针织衫肥佬胖子打底', '0', '149', '0|35|144|149|', '16', '12', '159.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('25', '26', '纺布者潮牌大码男装秋季加肥加大宽松衬衣胖子拼接男士长袖衬衫潮', '0', '149', '0|35|144|149|', '16', '12', '199.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('26', '27', '纺布者潮牌大码卫衣男加肥加大秋季新款男士长袖胖子时尚宽松上衣', '0', '2', '0|1|2|', '16', '12', '15.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('27', '28', '纺布者大码潮牌秋季毛衣男士胖子休闲加肥加大宽松圆领套头针织衫', '0', '275', '0|86|91|275|', '16', '12', '25.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('28', '29', '纺布者大码男装秋季加肥加大男士套头毛衣胖子针织衫秋款圆领毛衫', '0', '102', '0|86|91|102|', '16', '12', '59.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('29', '30', '吊裆裤哈伦裤男九分裤HIPHOP嘻哈宽松裤子潮牌加绒垮裤低裆拉裆裤', '0', '103', '0|86|91|103|', '16', '12', '199.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('30', '31', '男装加肥加大宽松胖子照片印花胖人黑色夹克外套轻薄', '0', '103', '0|86|91|103|', '16', '12', '155.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('31', '32', '冬季欧美仙鹤潮牌bf加绒刺绣卫衣男连帽中国风男装大码国潮外套潮', '0', '389', '0|38|39|389|', '16', '12', '59.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('32', '33', '唐狮秋冬装毛衣男女情侣装毛衣韩版宽松bf毛衫网红线衣针织衫', '0', '380', '0|1|377|380|', '16', '12', '59.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('33', '34', '唐狮情侣装毛衣男秋季新款圆领套头韩版学生针织衫线衣百搭上衣潮', '0', '377', '0|1|377|', '16', '12', '199.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('34', '35', '唐狮秋冬季情侣装毛衣男女韩版图案小清新圆领套头学生针织衫', '0', '79', '0|79|', '16', '12', '259.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('35', '36', '唐狮2018春装新款连帽套头卫衣男潮流潮牌男帽衫宽松个性男士外套', '0', '429', '0|35|429|', '16', '12', '125.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('36', '37', '男装秋冬羊毛呢子休闲西服纯手工双面呢韩版修身无羊绒小西装外套', '0', '397', '0|38|47|397|', '16', '12', '88.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('37', '38', '小西装男韩版修身冬季加厚上衣外套青年帅气呢子休闲西服呢料单西', '0', '163', '0|35|160|163|', '16', '12', '9000.99', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('38', '39', '猫人男装中长款羽绒服男冬季新款青年黑色修身连帽韩版休闲外套', '0', '39', '0|38|39|', '16', '12', '155.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('39', '40', 'JSMIX胖胖星球大码男装加肥加大宽松潮胖子趣味印花长袖T恤春季', '0', '106', '0|86|91|106|', '16', '12', '788.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('40', '41', 'JSMIX大码潮牌男装加肥加大宽松胖子裤子撞色拼接休闲裤长裤男裤', '0', '149', '0|35|144|149|', '16', '12', '2500.99', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('41', '42', '相宜本草光彩立现白茶睡眠面膜 补水保湿女滋润整晚养护专柜正品', '0', '120', '0|86|116|120|', '17', '18', '4559.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('42', '44', '伊贝诗深海绿洲醒肤液补水保湿深层清洁控油爽肤水保湿水化妆水', '0', '37', '0|35|36|37|', '17', '18', '799.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('43', '45', '瑜然美 美容橄榄油护肤精油护发身体按摩防干裂全身脸部刮痧外用', '0', '115', '0|86|109|115|', '17', '18', '599.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('44', '48', '百雀羚三生花舒缓细肤柔润凝乳精华乳液女补水保湿学生', '0', '168', '0|1|18|168|', '17', '18', '0.01', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('45', '49', '百雀羚小森羚温和净颜卸妆水脸部眼唇卸妆液清洁毛孔不油腻', '0', '21', '0|1|18|21|', '17', '18', '1599.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('46', '50', '百雀羚小森羚海棠身体乳润肤乳保湿滋润补水淡香润体乳学生少女', '0', '19', '0|1|18|19|', '17', '18', '2999.99', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('47', '51', '佳雪芦荟保湿霜3瓶量贩套装国货护肤品芦荟胶滋润补水面霜', '0', '19', '0|1|18|19|', '17', '18', '5999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('48', '58', 'innisfree/悦诗风吟轻澈洁面仪(吾皇万睡限量版)', '0', '111', '0|86|108|111|', '17', '18', '159.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('49', '59', '百雀羚三生花青春紧弹活颜美容液100ml 面部精华补水保湿紧致嫩', '0', '37', '0|35|36|37|', '17', '18', '169.99', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('50', '60', 'LA MER海蓝之谜臻璨焕活面部精华油 补水保湿修护', '0', '37', '0|35|36|37|', '17', '18', '159.99', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('51', '61', '法国正品玫瑰香水女士持久淡香清新自然专柜魅力学生礼物喷雾小样', '0', '137', '0|79|135|137|', '17', '18', '159.99', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('52', '62', '维维尼奥香水女士持久淡香水 法式精致淡香憧憬清新女香专柜正品', '0', '109', '0|86|109|', '17', '18', '12.50', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('53', '63', 'LA MER海蓝之谜赋活保湿精华露30ml 水润保湿 润泽', '0', '385', '0|38|39|385|', '17', '18', '199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('54', '64', 'SK-II sk2粉底skii棒棒糖粉凝霜 臻美焕透晶透粉霜遮瑕防晒SPF30', '0', '383', '0|38|39|383|', '17', '18', '169.99', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('55', '65', '兰蔻 黑金臻宠精华乳30ml 柔软平滑紧致光泽 淡细纹补水保湿滋润', '0', '385', '0|38|39|385|', '17', '18', '0.01', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('56', '101', '亲子装2017新款秋冬季母女装针织衫韩版宽松外穿毛衣纯色打底春装', '0', '58', '0|56|57|58|', '10', '9', '385.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('57', '102', '草莓南瓜亲子装2018新款母女装冬装白色羽绒服韩版中长款加厚外套', '0', '61', '0|56|57|61|', '10', '27', '199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('58', '103', '女童装旗袍新年唐装冬过年衣服3喜庆4岁中国风儿童拜年男套装宝宝', '0', '63', '0|56|62|63|', '10', '9', '119.80', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('59', '104', '双鹰遥控搅拌车工程车电动玩具水泥车混凝土罐车汽车模型儿童男孩', '0', '64', '0|56|62|64|', '10', '9', '58.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('60', '105', '宝贝第一 儿童安全座椅 婴儿安全座椅汽车用 0-6岁 车载宝宝座椅', '0', '65', '0|56|62|65|', '10', '9', '45.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('61', '107', '儿童电动车摇摆童车四轮室内车带遥控玩具车可坐人摩托车电动汽车', '0', '69', '0|56|66|69|', '10', '9', '67.32', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('62', '108', '特宝儿一岁男宝宝益智滑翔轨道车玩具小汽车儿童玩具车男孩2-3岁', '0', '70', '0|56|66|70|', '10', '9', '65.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('63', '109', '大型儿童电动车四轮卡丁车小孩玩具汽车宝宝遥控可坐人童车', '0', '426', '0|56|66|426|', '10', '27', '135.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('64', '110', '米兔故事机mini儿童早教机宝宝婴儿幼儿玩具学习机', '0', '72', '0|56|71|72|', '10', '9', '198.00', '1', '1');
INSERT INTO `es_sss_goods_data` VALUES ('65', '111', '亿宝莱高景观婴儿推车可坐可躺轻便携式折叠小孩宝宝双向婴儿童车', '0', '73', '0|56|71|73|', '10', '9', '59.80', '1', '1');
INSERT INTO `es_sss_goods_data` VALUES ('66', '112', '亲子装夏女童沙滩裙2017新母女装波西米亚长裙海边度假公主连衣裙', '0', '73', '0|56|71|73|', '10', '27', '85.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('67', '113', '过年亲子装冬装2018新款潮拜年服母女棉衣外套冬季棉服收腰中长款', '0', '74', '0|56|71|74|', '10', '9', '39.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('68', '114', '宝宝唐装冬周岁男童汉服儿童女童中国风过年拜年喜庆新年衣服套装', '0', '74', '0|56|71|74|', '10', '27', '68.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('69', '115', '亲子装冬装2018新款潮秋装母子母女装旗袍全家装一家三口唐装套装', '0', '78', '0|56|75|78|', '10', '27', '198.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('70', '116', '恬贝儿 亲子装秋装母女装连衣裙2017新款潮韩版中袖修身亲子礼服', '0', '201', '0|56|200|201|', '10', '9', '798.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('71', '117', '恬贝儿 母女装秋装连衣裙2017新款潮韩版亲子装秋冬女童礼服裙子', '0', '202', '0|56|200|202|', '10', '9', '409.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('72', '118', '女童三件套运动套装2017新款5宝宝3秋冬装4加绒卫衣6岁儿童装加厚', '0', '204', '0|56|200|204|', '10', '9', '249.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('73', '119', 'amii童装秋款亲子装小童休闲套装母女装纯棉卫衣裤子童装两件套', '0', '210', '0|56|208|210|', '10', '27', '1599.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('74', '120', '女童秋装套装2018新款韩版女孩中大童装春秋季儿童休闲运动两件套', '0', '214', '0|56|212|214|', '10', '27', '41.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('75', '121', '童装男童秋冬装套装2018新款儿童加绒加厚金丝绒卫衣三件套中大童', '0', '205', '0|56|200|205|', '10', '27', '996.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('76', '125', '旗袍连衣裙2018新款冬季名媛宴会晚礼服少女小香风复古中国风长款', '0', '98', '0|86|96|98|', '5', '9', '99.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('77', '126', 'VeroModa中腰破洞A版牛仔短裤女|316343009', '0', '99', '0|86|96|99|', '5', '9', '199.00', '0', '0');
INSERT INTO `es_sss_goods_data` VALUES ('78', '127', '宴会晚礼服2018新款高贵优雅性感长款香槟色鱼尾礼服裙女公司年会', '0', '100', '0|86|96|100|', '5', '9', '128.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('79', '128', '新娘2018新款秋冬季中式立领鱼尾长款长袖红色结婚晚礼服女', '0', '101', '0|86|96|101|', '5', '9', '398.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('80', '129', '冬季旗袍2018新款少女长袖连衣裙宴会派对聚会晚礼服短款公司年会', '0', '272', '0|86|96|272|', '5', '9', '551.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('81', '130', '2018裙子夏波西米亚长裙沙滩裙海边度假显瘦雪纺连衣裙', '0', '273', '0|86|96|273|', '5', '9', '229.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('82', '131', '泰国旅游沙滩裙女夏2017新款波西米亚海边度假显瘦性感连衣裙长裙', '0', '274', '0|86|96|274|', '5', '9', '799.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('83', '132', '职业装套装女2017新款时尚秋冬气质OL商务面试西装正装西服工作服', '0', '110', '0|86|108|110|', '5', '9', '369.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('84', '133', '玛玛绨2018春装新款个性刺绣休闲棒球服夹克女装时尚宽松短外套潮', '0', '112', '0|86|108|112|', '5', '9', '1298.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('85', '134', '金丝绒套装女2017冬季新款时尚休闲运动服女潮加绒加厚卫衣三件套', '0', '279', '0|86|108|279|', '5', '9', '1189.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('86', '135', '职业装女装套装女裤秋冬马甲西装正装面试OL上班修身气质工作服', '0', '280', '0|86|108|280|', '5', '9', '48.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('87', '136', '夜店女装2018秋冬新款时尚套装气质修身性感显瘦包臀连衣裙两件套', '0', '117', '0|86|116|117|', '5', '9', '198.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('88', '137', '运动服套装女春秋2017新款潮韩版女装时尚长袖卫衣显瘦休闲两件套', '0', '118', '0|86|116|118|', '5', '9', '698.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('89', '138', '琳卡索2018春季新款韩版宽松套头糖果色少女后交叉蝙蝠袖卫衣女潮', '0', '99', '0|86|96|99|', '5', '9', '1490.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('90', '139', '七格格一字肩喇叭袖上衣2017秋时尚宽松遮肉长袖中长款雪纺衫女薄', '0', '98', '0|86|96|98|', '5', '9', '198.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('91', '141', '韩都衣舍2018新款女装春装韩版连帽印花宽松显瘦打底休闲长袖卫衣', '0', '100', '0|86|96|100|', '5', '9', '199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('92', '142', '春秋连衣裙长袖女装2018新款韩版小清新潮时尚显瘦卫衣小个子学生', '0', '272', '0|86|96|272|', '5', '9', '274.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('93', '143', '七格格紫色卫衣女宽松bf2018春装新款学生长袖ins小清新上衣短款', '0', '110', '0|86|108|110|', '5', '9', '499.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('94', '144', '伊芙丽2018春装新款韩版长袖衬衣欧洲站chic宽松雪纺白衬衫女韩范', '0', '117', '0|86|116|117|', '5', '9', '398.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('95', '145', 'Paul Frank/大嘴猴17秋设计师款女士烫金印花学院风棒球服外套', '0', '118', '0|86|116|118|', '5', '9', '338.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('96', '148', '', '0', '37', '0|35|36|37|', '1', '1', '0.00', '0', '2');
INSERT INTO `es_sss_goods_data` VALUES ('97', '155', 'Fujifilm/富士X-A3套机单电自拍复古富士xa3微单相机', '0', '139', '0|79|135|139|', '1', '1', '318.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('98', '156', '狼蛛掌控者机械键盘青轴游戏背光单手守望先锋lol吃鸡电竞宏定义', '0', '246', '0|85|245|246|', '1', '1', '99.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('99', '157', '伊索正品精钢全自动机械表 时尚夜光手表男士防水多功能男表9027', '0', '164', '0|35|160|164|', '1', '1', '2350.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('100', '171', '联想（Lenovo）IdeaPad 500S 笔记本电脑', '161', '494', '0|491|492|494|', '18', '28', '5399.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('101', '172', '联想（Lenovo）Y50p-70 15.6英寸游戏笔记本', '161', '494', '0|491|492|494|', '18', '28', '6184.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('102', '173', '未来人类(Terrans Force)S4-1060-67S', '168', '494', '0|491|492|494|', '18', '28', '11999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('103', '174', 'Apple iPhone 7 Plus 128GB 亮黑色 ', '151', '497', '0|491|492|497|', '18', '28', '6448.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('104', '175', '美的(Midea)WFS3018Q智能可预约电饭煲 3升/3', '162', '501', '0|491|500|501|', '1', '29', '189.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('105', '176', '美的（Midea）MB-WFS4017TM 特色圆灶釜 智能', '162', '501', '0|491|500|501|', '1', '29', '299.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('106', '177', 'Apple iPhone 7 Plus 128GB 玫瑰金色', '151', '497', '0|491|492|497|', '18', '28', '6488.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('107', '178', 'HUAWEI nova（3GB+32GB）CAZ-TL10 ', '159', '497', '0|491|492|497|', '18', '28', '1596.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('108', '179', 'OPPO A57 全网通 3GB+32GB内存版 玫瑰金', '153', '497', '0|491|492|497|', '18', '28', '1799.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('109', '180', 'OPPO R9s Plus 6GB+64GB内存版 全网通4', '153', '497', '0|491|492|497|', '18', '28', '2099.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('110', '181', 'Xiaomi小米 红米Pro 高配版64G全网通手机-金色', '170', '497', '0|491|492|497|', '18', '28', '1228.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('111', '182', 'Xiaomi小米 红米Pro 高配版64G全网通手机-银色', '170', '497', '0|491|492|497|', '18', '28', '1288.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('112', '183', '锤子M1L白色-6G+64GB移动联通电信全网通公开版', '154', '497', '0|491|492|497|', '18', '28', '3184.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('113', '184', '罗技（Logitech）G402 高速追踪游戏鼠标 吃鸡鼠标', '173', '505', '0|491|502|505|', '1', '30', '249.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('114', '185', '锤子M1-咖啡金-4G+32GB 移动联通电信全网通', '154', '497', '0|491|492|497|', '18', '28', '2999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('115', '186', '红米Note 4 高配全网通版 3GB内存 64GB 金色', '170', '497', '0|491|492|497|', '18', '28', '1199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('116', '187', '华为 P9 (EVA-AL10) 4GB+64GB 琥珀金 ', '159', '497', '0|491|492|497|', '18', '28', '2899.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('117', '188', '华为荣耀NOTE 8 4GB+32GB 全网通版', '159', '497', '0|491|492|497|', '18', '28', '1999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('118', '189', '雷蛇（Razer）奥罗波若蛇 Ouroboros 游戏鼠标', '179', '505', '0|491|502|505|', '1', '30', '996.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('119', '190', '魅蓝X 珠光白 3+32G全网通公开版', '164', '497', '0|491|492|497|', '18', '28', '1199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('120', '191', '魅族 魅蓝note5 4G+全网通版 灰色 移动联通电信4G', '164', '497', '0|491|492|497|', '18', '28', '1049.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('121', '192', '魅族 魅蓝Note5 全网通公开版 32GB 月光银 移动联', '164', '497', '0|491|492|497|', '18', '28', '1049.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('122', '193', '海尔（Haier）BCD-310WDPF 310升多门冰箱 ', '157', '495', '0|491|493|495|', '18', '28', '3699.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('123', '194', '海尔（Haier）BCD-452WDPF 452升对开门冰箱', '157', '495', '0|491|493|495|', '18', '28', '3199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('124', '195', '华硕（ASUS）Spatha ROG玩家国度 游戏鼠标', '181', '505', '0|491|502|505|', '1', '30', '1299.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('125', '196', '美的(Midea)BCD-529WKGPZM(E) 529升', '162', '495', '0|491|493|495|', '18', '27', '3998.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('126', '197', '美菱(MELING) BCD-551WPCX 551升', '163', '495', '0|491|493|495|', '18', '27', '2999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('127', '198', '西门子(SIEMENS) BCD-610W(KA92NV03', '169', '495', '0|491|493|495|', '18', '27', '6599.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('128', '199', 'TCL D55A620U 55英寸 观影王4K版', '155', '496', '0|491|493|496|', '18', '27', '3999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('129', '200', '创维(Skyworth) 55M7 55英寸', '156', '496', '0|491|493|496|', '18', '27', '2799.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('130', '201', '海尔(Haier)LE32B310P 32英寸 蓝光全高清 ', '157', '496', '0|491|493|496|', '18', '27', '999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('131', '202', '海信(Hisense)LED50EC660US 50英寸', '158', '496', '0|491|493|496|', '18', '28', '2799.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('132', '203', '小米（MI）米家IH电饭煲 智能电饭煲 IH电磁环绕加热 手', '170', '501', '0|491|500|501|', '1', '29', '399.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('133', '204', '海信(Hisense)LED55EC660US 55英寸', '158', '496', '0|491|493|496|', '18', '28', '3199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('134', '205', '美的（Midea）微波炉M1-L213C 21L 家用 转盘', '162', '511', '0|491|500|511|', '1', '29', '359.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('135', '206', '海信(Hisense)LED65EC780UC 65英寸 ', '158', '496', '0|491|493|496|', '18', '28', '7599.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('136', '207', '三星(SAMSUNG)UA55JU50SWJXXZ', '165', '496', '0|491|493|496|', '18', '27', '3299.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('137', '208', '索尼(SONY)KD-55X8500D 55英寸 ', '167', '496', '0|491|493|496|', '18', '28', '6999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('138', '209', '索尼(SONY)KDL-48W650D 48英寸 全高清LE', '167', '496', '0|491|493|496|', '18', '28', '3199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('139', '210', '长虹(CHANGHONG)60G3 60英寸25核轻薄4K ', '172', '496', '0|491|493|496|', '18', '27', '4399.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('140', '211', '三洋（SANYO）WF810326BS0S 8公斤', '166', '498', '0|491|493|498|', '18', '28', '1738.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('141', '212', '三洋（SANYO）WT8455M0S 8公斤', '166', '498', '0|491|493|498|', '18', '28', '998.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('142', '213', '西门子(SIEMENS) XQG70-WM10N0600W ', '169', '498', '0|491|493|498|', '18', '28', '2498.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('143', '214', '西门子(SIEMENS) XQG90-WM12P2681W ', '169', '498', '0|491|493|498|', '18', '28', '4498.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('144', '215', '小天鹅(Little Swan)TB80-Mute60WD ', '171', '498', '0|491|493|498|', '18', '27', '1398.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('145', '216', 'Apple苹果 iPhone 8 64GB', '151', '497', '0|491|492|497|', '18', '28', '6338.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('146', '217', '【惠普杨洋定制本】惠普(HP)畅游人Pavilion', '160', '494', '0|491|492|494|', '18', '27', '4998.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('147', '218', 'Apple iPad Pro 平板电脑', '151', '499', '0|491|492|499|', '18', '27', '7684.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('148', '219', 'Apple MacBook Air11.6英寸笔记本电脑', '151', '494', '0|491|492|494|', '18', '27', '4499.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('149', '220', '罗技（Logitech)G502 游戏鼠标', '173', '505', '0|491|502|505|', '1', '30', '329.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('150', '221', '戴尔（DELL）Vostro成就 14TR-5625SS ', '152', '494', '0|491|492|494|', '18', '27', '4699.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('151', '222', '戴尔（DELL）成就Vostro 15-3559-2628B', '152', '494', '0|491|492|494|', '18', '27', '6599.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('152', '223', '雷蛇（Razer） Deathadder 炼狱蝰蛇1800 ', '179', '505', '0|491|502|505|', '1', '30', '149.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('153', '224', '美的（Midea）嵌入式微波炉 TG025QPS-NSH 2', '162', '511', '0|491|500|511|', '1', '29', '2299.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('154', '225', '罗技（Logitech）G610 Cherry轴全尺寸背光 ', '173', '506', '0|491|502|506|', '1', '30', '499.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('155', '226', 'OPPO R11 Plus 6GB+64GB 玫瑰金', '153', '497', '0|491|492|497|', '18', '28', '3699.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('156', '227', '樱桃（Cherry）机械键盘G80-3000LSCEU-0白', '180', '506', '0|491|502|506|', '1', '30', '699.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('157', '228', '未来人类(Terrans Force) T5-1060-67', '168', '494', '0|491|492|494|', '18', '27', '8499.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('158', '229', 'Razer雷蛇 黑寡妇蜘蛛V2幻彩版 lol电竞游戏机械键盘', '179', '506', '0|491|502|506|', '1', '30', '1079.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('159', '230', '小米（MI）小米便携鼠标 智能轻薄便携 无线+蓝牙双连接 家', '170', '505', '0|491|502|505|', '1', '30', '99.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('160', '231', 'Razer雷蛇 Overwatch守望先锋游戏机械键盘 电脑', '179', '506', '0|491|502|506|', '1', '29', '1299.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('161', '232', ' 小米6 全网通 6GB+128GB 探索银限量版', '170', '497', '0|491|492|497|', '18', '28', '4799.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('162', '233', 'Cherry樱桃 MX-BOARD 9.0全无冲炫彩发光背光', '180', '506', '0|491|502|506|', '1', '30', '1369.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('163', '234', '三星 Galaxy S8 Plus S8+（G9550）6G', '165', '497', '0|491|492|497|', '18', '28', '7288.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('164', '235', 'CHERRY樱桃MX8.0背光87键机械键盘', '180', '506', '0|491|502|506|', '1', '29', '1719.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('165', '236', ' 三星手机SM-W2017', '165', '497', '0|491|492|497|', '18', '28', '12999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('166', '237', '华硕（ASUS）RT-AC66U B1 AC双频1750M路', '181', '508', '0|491|502|508|', '1', '30', '649.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('167', '238', '小米路由器3G 双千兆光纤宽带穿墙王 高增益四天线 散热好 ', '170', '508', '0|491|502|508|', '1', '30', '249.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('168', '239', '华为（HUAWEI）联通/电信双4G版无线路由器 移动随身随', '159', '508', '0|491|502|508|', '1', '30', '349.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('169', '240', '华为 Mate10 全网通版 6GB+128GB', '159', '497', '0|491|492|497|', '18', '28', '9999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('170', '241', ' 惠普(HP)暗影精灵III代Plus17.3英寸 ', '160', '494', '0|491|492|494|', '18', '27', '13468.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('171', '242', 'Apple iPad MP2G2CH A 9.7英寸', '151', '499', '0|491|492|499|', '18', '28', '2588.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('172', '243', ' 【送大礼包】华为(HUAWEI) 荣耀平板2 8英寸', '159', '499', '0|491|492|499|', '18', '27', '1199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('173', '244', '联想(Lenovo) MIIX320 10.1英寸', '161', '499', '0|491|492|499|', '18', '28', '2458.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('174', '246', '海尔（Haier）BCD-216SDN 216升三门直冷冰箱 电脑智能控温 家用', '157', '495', '0|491|493|495|', '18', '31', '1599.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('175', '247', '小米（MI）wifi 电力猫 穿墙宝 搭配路由器使用 白色', '170', '508', '0|491|502|508|', '1', '30', '249.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('176', '249', '三星（SAMSUNG）BAR系列 32G 全金属五防 USB3.0 高速U盘 高速闪存盘 金属银', '165', '509', '0|491|502|509|', '1', '30', '82.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('177', '250', ' 金立 大金钢2 全面屏 尊爵金 4G+64GB 全网通4G手机 双卡双待大电池智能手机', '182', '497', '0|491|492|497|', '18', '27', '1999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('178', '251', '三星（SAMSUNG）移动固态硬盘SSD T5 500GB （MU-PA500B/CN）', '165', '510', '0|491|502|510|', '1', '30', '1337.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('179', '252', 'nubia努比亚Z17 畅享版 6GB+64GB 黑金 移动联通电信手机 无边框', '183', '497', '0|491|492|497|', '18', '27', '2000.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('180', '253', '三星（SAMSUNG）移动固态硬盘SSD T5 2TB （MU-PA2T0B/CN）', '165', '510', '0|491|502|510|', '1', '30', '5999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('181', '254', '三星（SAMSUNG）移动固态硬盘SSD T5 1TB （MU-PA1T0B/CN）', '165', '510', '0|491|502|510|', '1', '30', '2999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('182', '255', 'nubia努比亚 Z17S (NX595J) 6GB+64GB 黑金 移动联通电信4G手机 无边框', '183', '497', '0|491|492|497|', '18', '27', '2999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('183', '256', '【保值之选】Apple iPhone 6 32G 金 移动联通电信4G 手机', '151', '497', '0|491|492|497|', '18', '27', '2449.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('184', '257', 'Xiaomi小米 小米手机Max2 4GB+64GB 金色 移动联通电信4G大屏手机', '170', '497', '0|491|492|497|', '18', '27', '1699.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('185', '258', 'Xbox One S 1TB双手柄竞技版 含体感器及三国志、最终幻想等11款游戏', '184', '519', '0|491|503|519|', '1', '30', '4788.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('186', '259', 'honor荣耀V9 play标配版 3GB+32GB 幻夜黑', '187', '497', '0|491|492|497|', '18', '27', '999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('187', '260', '任天堂 Nintendo switch掌上游戏机便携式掌机Switch NS主机（红蓝手柄）+塞尔达', '185', '519', '0|491|503|519|', '1', '30', '3128.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('188', '261', '索尼 Sony PlayStation 4 PS4 Pro 国行游戏主机 HDR色彩 支持4K 1TB容量 黑色', '186', '519', '0|491|503|519|', '1', '30', '3299.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('189', '264', 'vivo X20 4GB+64GB 磨砂黑 移动联通电信4G手机 全面屏拍照 面部识别', '188', '497', '0|491|492|497|', '18', '27', '2998.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('190', '265', '索尼（SONY）【PS4 官方配件】PS4 slim /PSV/PS4 Pro7.1声道 白金版无线头戴耳机', '167', '520', '0|491|503|520|', '1', '29', '1299.00', '1', '1');
INSERT INTO `es_sss_goods_data` VALUES ('191', '266', 'Huawei华为麦芒6 4GB+64GB 曜石黑 移动联通电信4G手机', '159', '497', '0|491|492|497|', '18', '27', '2399.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('192', '267', 'Huawei华为 畅享7（SLA-AL00）3GB+32GB 香槟金 移动联通电信4G手机 高配版', '159', '497', '0|491|492|497|', '18', '27', '1099.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('193', '268', '微软（Microsoft) Xbox 无线控制器 （蓝牙连接 带3.5mm的耳机接头 白色）', '184', '521', '0|491|503|521|', '1', '30', '429.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('194', '269', '索尼（SONY）PlayStation4游戏手柄 新款PS4无线控制器（蓝色）', '186', '521', '0|491|503|521|', '1', '30', '380.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('195', '270', 'vivo X9s 4GB+64GB 玫瑰金 移动联通电信4G拍照手机 双卡双待', '188', '497', '0|491|492|497|', '18', '27', '2498.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('196', '271', '华硕(ASUS)灵耀S4000 14英寸笔记本电脑(i5-7200U 8G 256GSSD 620核心显卡 金属', '181', '494', '0|491|492|494|', '18', '27', '4899.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('197', '272', '华硕(ASUS)飞行堡垒二代FX53 15.6英寸游戏笔记本电脑(i7-7700 8G 1T+128 4G红黑)', '181', '494', '0|491|492|494|', '18', '27', '7099.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('198', '273', '索尼（SONY）PS4 Slim Pro 正版游戏软件 实体光盘 GTA5 猎车手5', '186', '522', '0|491|503|522|', '1', '30', '298.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('199', '274', '雷神911 SE-E5a 15.6英寸游戏笔记本电脑I7-7700HQ 8G 128+1T GTX1050', '190', '494', '0|491|492|494|', '18', '27', '6199.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('200', '275', '联想(Lenovo)拯救者Y520 15.6英寸游戏笔记本电脑(I7-7700 8G 1T+128G 4G独显 ', '161', '494', '0|491|492|494|', '18', '27', '8999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('201', '276', '华硕ASUS KZX53VE7700 15.6英寸笔记本电脑I7-7700 8G 1T 128G固态GTX1050ti', '181', '494', '0|491|492|494|', '18', '27', '7248.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('202', '279', ' 戴尔DELL INS15-7567湛黑版15.6英寸笔记本电脑i7-7700 8G 1T+128G固态GTX1050t', '152', '494', '0|491|492|494|', '18', '27', '7288.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('203', '280', ' 戴尔（DELL）游匣15-7577-R1765B 15.6英寸 i7-7700HQ 16G 256G+1T 6G独显', '152', '494', '0|491|492|494|', '18', '27', '10099.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('204', '282', '雷神 911GT-Y6 17.3英寸大屏游戏本笔记本i7-7700HQ 16G 256G+1T GTX1060', '190', '494', '0|491|492|494|', '18', '27', '0.50', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('205', '283', '未来人类(Terrans Force) X911-1080S-77X 桌面级i7-7700K 双GTX1080显卡 新', '168', '494', '0|491|492|494|', '18', '27', '39888.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('206', '284', '九阳（Joyoung）电饭煲 JYF-30FE09 3升 多功能 7段智能温控 黄晶内胆 电饭锅', '162', '501', '0|491|500|501|', '1', '29', '0.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('207', '285', '【三只松鼠_碧根果210gx2袋】零食坚果炒货山核桃长寿果干果奶油味 奶油口味', '3', '6', '0|1|2|6|', '1', '29', '38.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('208', '286', '资生堂 珊珂 绵润泡沫洁面乳 120g', '61', '40', '0|38|39|40|', '1', '34', '52.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('209', '287', '倩碧 CLINIQUE补水保湿润肤乳（黄油有油）黄油圣品125ml 美国直采', '53', '42', '0|38|39|42|', '1', '34', '159.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('210', '288', 'LANCOME 兰蔻清滢保湿柔肤水粉水400ml 补水滋润正品大瓶装', '60', '385', '0|38|39|385|', '1', '34', '339.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('211', '289', '美素佳儿（Friso）金装幼儿配方奶粉 3段（1-3岁幼儿适用）900克（荷兰原装进口）', '0', '58', '0|56|57|58|', '1', '29', '167.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('212', '290', '爱他美（Aptamil）幼儿配方奶粉 3段(12-36个月适用) 800g （德国原装进口）', '0', '59', '0|56|57|59|', '1', '1', '185.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('213', '291', '德运Devondale 全脂高钙成人奶粉 1KG', '66', '22', '0|4|5|22|', '1', '33', '49.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('214', '292', '【内蒙古乌兰察布】草原星 内蒙特产牛肉干手撕500g实惠装 香辣味', '2', '306', '0|1|2|306|', '1', '33', '69.80', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('215', '293', '费列罗FerreroRocher进口巧克力榛仁夹心巧克力婚庆喜糖礼盒节日礼物礼品T30粒装*2盒七夕情人节礼物', '11', '10', '0|1|3|10|', '1', '33', '126.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('216', '294', 'Ferrero Rocher费列罗威化榛仁夹心巧克力T3*16粒装意大利进口婚庆喜糖巧克力礼盒装节日礼物礼品', '11', '10', '0|1|3|10|', '1', '29', '119.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('217', '295', 'COCA-COLA可口可乐汽水樱桃口味355ml（美国进口 听）*12整箱装', '13', '14', '0|1|13|14|', '1', '1', '59.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('218', '296', '安溪馆 三和清香型安溪铁观音茶叶一级 铁盒装250g', '35', '289', '0|1|288|289|', '1', '1', '35.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('219', '297', '南国往事一枕清霜 茶叶 陈年普洱熟茶 七子饼茶 云南普尔茗茶 357g 包邮', '0', '290', '0|1|288|290|', '1', '29', '39.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('220', '298', 'Apple iPhone 8 Plus 64GB 金色 移动联通电信4G手机', '151', '497', '0|491|492|497|', '18', '27', '6688.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('221', '299', '三星 Galaxy S7 edge（G9350）4+64G版 铂光金 全网通', '165', '497', '0|491|492|497|', '18', '27', '3299.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('222', '300', 'honor荣耀V9高配版 6GB+64GB 铂光金 移动联通电信4G手机', '187', '497', '0|491|492|497|', '18', '27', '2699.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('223', '301', 'honor荣耀8 4GB+64GB 魅海蓝 移动联通电信4G手机', '187', '497', '0|491|492|497|', '18', '27', '1699.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('224', '302', 'honor荣耀畅玩7X尊享版 4GB+128GB 铂光金 移动联通电信4G手机', '187', '497', '0|491|492|497|', '18', '27', '1999.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('225', '303', '戴尔（DELL）灵越 13-7370-R1505S 13.3英寸轻薄笔记本电脑（i5-8250U 8G 128G', '152', '494', '0|491|492|494|', '18', '27', '6099.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('226', '304', 'A', '2', '7', '0|1|2|7|', '15', '2', '100.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('227', '305', 'B', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('228', '306', 'C', '151', '494', '0|491|492|494|', '1', '29', '20.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('229', '307', 'A1', '2', '7', '0|1|2|7|', '15', '2', '100.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('230', '308', 'B1', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('231', '309', 'C1', '2', '7', '0|1|2|7|', '1', '1', '20.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('232', '310', 'D1', '2', '7', '0|1|2|7|', '15', '2', '10.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('233', '311', 'E1', '2', '7', '0|1|2|7|', '15', '2', '10.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('234', '312', '促销商品A', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('235', '313', '促销商品B', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('236', '314', '促销商品C', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('237', '315', '促销商品D', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('238', '316', '促销商品E', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('239', '317', '促销商品F', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('240', '318', '促销商品G', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('241', '319', '促销商品H', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('242', '320', '促销商品I', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('243', '321', '促销商品J', '2', '7', '0|1|2|7|', '15', '2', '50.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('244', '322', '促销商品K', '2', '7', '0|1|2|7|', '1', '1', '100.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('245', '323', '小米（MI）知吾煮汤锅 铝材锅身 耐腐蚀易清洁 食品级不黏涂层 导磁锅底 米家定制电磁炉煲汤锅 家用多功能火锅', null, '81', '0|79|80|81|', '1', null, '99.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('246', '324', '苏泊尔/SUPOR汤锅304不锈钢炖锅ST22Z1加厚家用锅具电磁炉燃气灶通用', null, '81', '0|79|80|81|', '1', null, '149.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('247', '325', '九阳（Joyoung）电水壶 K17-F66 容量1.7L 国产温控器 不锈钢电热水壶双层保温防烫 无缝内胆烧水壶', null, '82', '0|79|80|82|', '1', null, '90.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('248', '326', '美的（Midea）电水壶 WSJ1702b 1.7L 优质温控器 食品级304不锈钢 电热水瓶 电热水壶 电水壶', null, '82', '0|79|80|82|', '1', null, '79.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('249', '327', '爱仕达（ASD) 炒锅 NWG8330E 30CM易清洗 不粘锅 少油烟 不粘炒锅 电磁炉通用送原装木铲', null, '83', '0|79|80|83|', '1', null, '99.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('250', '328', '苏泊尔（SUPOR）炒锅NC32F4易洁不粘锅 32cm 少油烟 送原装木铲', null, '83', '0|79|80|83|', '1', null, '169.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('251', '329', '富光（FUGUANG) 玻璃杯WFB1020-500 500ml男女士带茶隔 便携创意双层泡茶玻璃水杯 500ml', null, '125', '0|79|124|125|', '1', null, '10.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('252', '330', '乐扣乐扣（lock&amp;lock）塑料杯 杯子水杯 随手杯 470ML HPL931', null, '126', '0|79|124|126|', '1', null, '11.90', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('253', '331', '东道 汝窑坐禅茶组 汝窑茶具套装开片汝瓷功夫整套茶具 坐禅小茶组一壶三杯-天青', null, '131', '0|79|130|131|', '1', null, '20.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('254', '332', '东道 汝窑 茶具配件 茶杯 品茗杯 小喜乐杯 开片可养金线 天青色 陶瓷 其他', null, '132', '0|79|130|132|', '1', null, '186.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('255', '333', '张小泉 (Zhang Xiao Quan) NS-7 合金指甲剪修甲剪刀脚趾剪子', null, '221', '0|79|219|221|', '1', null, '12.00', '0', '1');
INSERT INTO `es_sss_goods_data` VALUES ('256', '334', 'LANCOME 兰蔻清滢保湿柔肤水大粉水400ml爽肤水女补水保湿补水滋润营养正品大瓶装 法国进口【最新版本】', '60', '383', '0|38|39|383|', '1', null, '309.00', '0', '1');

-- ----------------------------
-- Table structure for `es_sss_goods_pv`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_goods_pv`;
CREATE TABLE `es_sss_goods_pv` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `seller_id` int(10) DEFAULT NULL COMMENT '店铺id',
  `goods_id` int(10) DEFAULT NULL COMMENT '商品id',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `vs_year` int(10) DEFAULT NULL COMMENT '年份',
  `vs_num` int(20) DEFAULT NULL COMMENT '访问量',
  `vs_month` int(10) DEFAULT NULL COMMENT '月份',
  `vs_day` int(10) DEFAULT NULL COMMENT '天',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='商品访问量统计表(es_sss_goods_pv)';

-- ----------------------------
-- Records of es_sss_goods_pv
-- ----------------------------
INSERT INTO `es_sss_goods_pv` VALUES ('1', '15', '10', '百草味牛轧奶芙(蔓越莓味)160g 沙琪玛牛萨萨糕点心', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv` VALUES ('2', '15', '1', '百草味菠萝干100g 菠萝块凤梨干/片蜜饯水果干小吃', '2018', '8', null, '4');
INSERT INTO `es_sss_goods_pv` VALUES ('3', '15', '2', '百草味手剥松子128g 坚果炒货干果特产开口手拨瓜子大籽', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv` VALUES ('4', '15', '15', '洋河蓝色经典 海之蓝52度375ml 2瓶 洋河官方旗舰店 绵柔型白酒', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv` VALUES ('5', '15', '1', '百草味菠萝干100g 菠萝块凤梨干/片蜜饯水果干小吃', '2018', '8', null, '3');
INSERT INTO `es_sss_goods_pv` VALUES ('6', '15', '16', '熊孩子 综合水果干108gx2袋混合装果干什锦脱水蔬果脆片休闲零食', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv` VALUES ('7', '15', '2', '百草味手剥松子128g 坚果炒货干果特产开口手拨瓜子大籽', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv` VALUES ('8', '15', '15', '洋河蓝色经典 海之蓝52度375ml 2瓶 洋河官方旗舰店 绵柔型白酒', '2018', '8', null, '2');
INSERT INTO `es_sss_goods_pv` VALUES ('9', '15', '16', '熊孩子 综合水果干108gx2袋混合装果干什锦脱水蔬果脆片休闲零食', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv` VALUES ('10', '15', '15', '洋河蓝色经典 海之蓝52度375ml 2瓶 洋河官方旗舰店 绵柔型白酒', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv` VALUES ('11', '15', '1', '百草味菠萝干100g 菠萝块凤梨干/片蜜饯水果干小吃', '2018', '8', null, '1');

-- ----------------------------
-- Table structure for `es_sss_goods_pv_2015`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_goods_pv_2015`;
CREATE TABLE `es_sss_goods_pv_2015` (
  `id` int(10) NOT NULL DEFAULT '0',
  `seller_id` int(10) DEFAULT NULL,
  `goods_id` int(10) DEFAULT NULL,
  `goods_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `vs_year` int(10) DEFAULT NULL,
  `vs_month` int(10) DEFAULT NULL,
  `vs_day` int(10) DEFAULT NULL,
  `vs_num` int(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_goods_pv_2015
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_goods_pv_2017`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_goods_pv_2017`;
CREATE TABLE `es_sss_goods_pv_2017` (
  `id` int(10) NOT NULL DEFAULT '0',
  `seller_id` int(10) DEFAULT NULL,
  `goods_id` int(10) DEFAULT NULL,
  `goods_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `vs_year` int(10) DEFAULT NULL,
  `vs_month` int(10) DEFAULT NULL,
  `vs_day` int(10) DEFAULT NULL,
  `vs_num` int(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_goods_pv_2017
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_goods_pv_2018`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_goods_pv_2018`;
CREATE TABLE `es_sss_goods_pv_2018` (
  `id` int(10) NOT NULL DEFAULT '0',
  `seller_id` int(10) DEFAULT NULL,
  `goods_id` int(10) DEFAULT NULL,
  `goods_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `vs_year` int(10) DEFAULT NULL,
  `vs_month` int(10) DEFAULT NULL,
  `vs_day` int(10) DEFAULT NULL,
  `vs_num` int(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_goods_pv_2018
-- ----------------------------
INSERT INTO `es_sss_goods_pv_2018` VALUES ('1', '15', '10', '百草味牛轧奶芙(蔓越莓味)160g 沙琪玛牛萨萨糕点心', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('2', '15', '1', '百草味菠萝干100g 菠萝块凤梨干/片蜜饯水果干小吃', '2018', '8', null, '4');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('3', '15', '2', '百草味手剥松子128g 坚果炒货干果特产开口手拨瓜子大籽', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('4', '15', '15', '洋河蓝色经典 海之蓝52度375ml 2瓶 洋河官方旗舰店 绵柔型白酒', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('5', '15', '1', '百草味菠萝干100g 菠萝块凤梨干/片蜜饯水果干小吃', '2018', '8', null, '3');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('6', '15', '16', '熊孩子 综合水果干108gx2袋混合装果干什锦脱水蔬果脆片休闲零食', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('7', '15', '2', '百草味手剥松子128g 坚果炒货干果特产开口手拨瓜子大籽', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('8', '15', '15', '洋河蓝色经典 海之蓝52度375ml 2瓶 洋河官方旗舰店 绵柔型白酒', '2018', '8', null, '2');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('9', '15', '16', '熊孩子 综合水果干108gx2袋混合装果干什锦脱水蔬果脆片休闲零食', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('10', '15', '15', '洋河蓝色经典 海之蓝52度375ml 2瓶 洋河官方旗舰店 绵柔型白酒', '2018', '8', null, '1');
INSERT INTO `es_sss_goods_pv_2018` VALUES ('11', '15', '1', '百草味菠萝干100g 菠萝块凤梨干/片蜜饯水果干小吃', '2018', '8', null, '1');

-- ----------------------------
-- Table structure for `es_sss_goods_pv_2019`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_goods_pv_2019`;
CREATE TABLE `es_sss_goods_pv_2019` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) DEFAULT NULL,
  `goods_id` int(10) DEFAULT NULL,
  `goods_name` varchar(255) DEFAULT NULL,
  `vs_year` int(10) DEFAULT NULL,
  `vs_month` int(10) DEFAULT NULL,
  `vs_day` int(10) DEFAULT NULL,
  `vs_num` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1298 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `es_sss_member_register_data`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_member_register_data`;
CREATE TABLE `es_sss_member_register_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `member_id` int(10) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(255) DEFAULT NULL COMMENT '会员名字',
  `create_time` int(12) DEFAULT NULL COMMENT '注册日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='注册会员信息(es_sss_member_register_data)';

-- ----------------------------
--  Records of `es_sss_member_register_data`
-- ----------------------------
BEGIN;
INSERT INTO `es_sss_member_register_data` VALUES ('76', '2', 'javashop', '1421329021'), ('77', '6', 'demo_woman', '1427854864'), ('78', '11', 'toys', '1427962143'), ('79', '16', 'food', '1428651298'), ('80', '25', 'superman', '1464430868'), ('81', '26', 'kans', '1464509078'), ('82', '27', 'appliance', '1508506621'), ('83', '28', 'kanon', '1509000654'), ('84', '29', 'wanghui', '1509000745'), ('85', '30', 'xulipeng', '1509000772'), ('86', '31', 'spring', '1509009430'), ('87', '32', 'martin', '1509009465'), ('88', '33', 'java', '1509009516'), ('89', '34', '六月的雨', '1509009562'), ('90', '35', '陈冠希_', '1509009674'), ('91', '36', '秋刀鱼的滋味', '1509009737'), ('92', '37', '春风十里_不如你', '1509009786'), ('93', '38', '下个路口见', '1509009923'), ('94', '39', 'batman', '1509073225'), ('95', '40', 'spiderman', '1509073858'), ('96', '41', 'antman', '1509074080'), ('97', '42', 'ironman', '1509074212'), ('98', '43', 'hock', '1509074489'), ('99', '44', 'eagle', '1509075137'), ('100', '45', 'green', '1509075866'), ('101', '46', 'blue', '1509084831'), ('102', '47', 'black', '1509084961'), ('103', '48', 'lion', '1509085091'), ('104', '49', '麦芽糖_', '1509431392'), ('105', '50', '回到过去', '1509433744'), ('106', '51', 'm_18555555555', '1534837036'), ('107', '52', 'fengkun', '1534917930'), ('108', '53', 'chopper', '1535340715'), ('109', '54', 'AAA', '1535442162'), ('110', '55', 'javashop7', '1535443163');
COMMIT;

-- ----------------------------
-- Table structure for `es_sss_order_data`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_data`;
CREATE TABLE `es_sss_order_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
  `buyer_id` int(10) DEFAULT NULL COMMENT '会员id',
  `buyer_name` varchar(255) DEFAULT NULL COMMENT '商家名称',
  `seller_id` int(10) DEFAULT NULL COMMENT '商家id',
  `seller_name` varchar(255) DEFAULT NULL COMMENT '商家名称',
  `order_status` varchar(255) DEFAULT NULL COMMENT '订单状态',
  `pay_status` varchar(255) DEFAULT NULL COMMENT '付款状态',
  `order_price` decimal(20,2) DEFAULT NULL COMMENT '订单金额',
  `goods_num` int(10) DEFAULT NULL COMMENT '订单商品数量',
  `ship_province_id` int(10) DEFAULT NULL COMMENT '省id',
  `ship_city_id` int(10) DEFAULT NULL COMMENT '市id',
  `create_time` int(12) DEFAULT NULL COMMENT '订单创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='订单数据(es_sss_order_data)';

-- ----------------------------
-- Records of es_sss_order_data
-- ----------------------------
INSERT INTO `es_sss_order_data` VALUES ('1', '20180821000016', '50', '回到过去', '1', '平台自营', 'COMPLETE', 'PAY_YES', '249.00', '3', '2', '2813', '1534847476');
INSERT INTO `es_sss_order_data` VALUES ('2', '20180821000015', '50', '回到过去', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '22597.95', '7', '2', '2813', '1534847476');
INSERT INTO `es_sss_order_data` VALUES ('3', '20180821000014', '50', '回到过去', '16', 'superman', 'COMPLETE', 'PAY_YES', '15.90', '1', '2', '2813', '1534847476');
INSERT INTO `es_sss_order_data` VALUES ('4', '20180821000013', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '11999.00', '1', '2', '2813', '1534847476');
INSERT INTO `es_sss_order_data` VALUES ('5', '20180821000012', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '11997.00', '1', '2', '2813', '1534847342');
INSERT INTO `es_sss_order_data` VALUES ('6', '20180821000010', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3182.00', '1', '2', '2813', '1534847309');
INSERT INTO `es_sss_order_data` VALUES ('7', '20180821000009', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '2997.00', '1', '2', '2813', '1534847294');
INSERT INTO `es_sss_order_data` VALUES ('8', '20180821000011', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '6486.00', '1', '2', '2813', '1534847327');
INSERT INTO `es_sss_order_data` VALUES ('9', '20180821000007', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3697.00', '1', '2', '2813', '1534847262');
INSERT INTO `es_sss_order_data` VALUES ('10', '20180821000008', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '1199.00', '1', '2', '2813', '1534847277');
INSERT INTO `es_sss_order_data` VALUES ('11', '20180821000001', '16', 'food', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '67.32', '1', '6', '303', '1534846758');
INSERT INTO `es_sss_order_data` VALUES ('12', '20180821000002', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '6099.00', '1', '2', '2813', '1534847172');
INSERT INTO `es_sss_order_data` VALUES ('13', '20180821000003', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '1596.00', '1', '2', '2813', '1534847204');
INSERT INTO `es_sss_order_data` VALUES ('14', '20180821000004', '50', '回到过去', '1', '平台自营', 'COMPLETE', 'PAY_YES', '2299.00', '1', '2', '2813', '1534847216');
INSERT INTO `es_sss_order_data` VALUES ('15', '20180821000005', '50', '回到过去', '1', '平台自营', 'COMPLETE', 'PAY_YES', '189.00', '1', '2', '2813', '1534847228');
INSERT INTO `es_sss_order_data` VALUES ('16', '20180821000006', '50', '回到过去', '1', '平台自营', 'COMPLETE', 'PAY_YES', '2299.00', '1', '2', '2813', '1534847240');
INSERT INTO `es_sss_order_data` VALUES ('17', '20180821000036', '27', 'appliance', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '4556.90', '4', '1', '2800', '1534848112');
INSERT INTO `es_sss_order_data` VALUES ('18', '20180821000034', '27', 'appliance', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '1778.00', '2', '1', '2800', '1534848112');
INSERT INTO `es_sss_order_data` VALUES ('19', '20180821000035', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '62861.00', '6', '1', '2800', '1534848112');
INSERT INTO `es_sss_order_data` VALUES ('20', '20180821000033', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '19337.00', '2', '1', '2800', '1534847978');
INSERT INTO `es_sss_order_data` VALUES ('21', '20180821000032', '27', 'appliance', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '249.00', '1', '1', '2800', '1534847964');
INSERT INTO `es_sss_order_data` VALUES ('22', '20180821000031', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '4799.00', '1', '1', '2800', '1534847947');
INSERT INTO `es_sss_order_data` VALUES ('23', '20180821000030', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '1778.00', '2', '1', '2800', '1534847947');
INSERT INTO `es_sss_order_data` VALUES ('24', '20180821000028', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3699.00', '1', '1', '2800', '1534847900');
INSERT INTO `es_sss_order_data` VALUES ('25', '20180821000025', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '399.00', '1', '1', '2800', '1534847855');
INSERT INTO `es_sss_order_data` VALUES ('26', '20180821000021', '27', 'appliance', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '2599.00', '1', '1', '2800', '1534847789');
INSERT INTO `es_sss_order_data` VALUES ('27', '20180821000027', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '1738.00', '1', '1', '2800', '1534847888');
INSERT INTO `es_sss_order_data` VALUES ('28', '20180821000029', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '120.00', '1', '1', '2800', '1534847921');
INSERT INTO `es_sss_order_data` VALUES ('29', '20180821000024', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '6798.00', '2', '1', '2800', '1534847855');
INSERT INTO `es_sss_order_data` VALUES ('30', '20180821000022', '27', 'appliance', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '4198.00', '2', '1', '2800', '1534847803');
INSERT INTO `es_sss_order_data` VALUES ('31', '20180821000023', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '399.00', '1', '1', '2800', '1534847828');
INSERT INTO `es_sss_order_data` VALUES ('32', '20180821000020', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '1299.00', '1', '1', '2800', '1534847756');
INSERT INTO `es_sss_order_data` VALUES ('33', '20180821000019', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3699.00', '1', '1', '2800', '1534847748');
INSERT INTO `es_sss_order_data` VALUES ('34', '20180821000026', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '10198.00', '2', '1', '2800', '1534847874');
INSERT INTO `es_sss_order_data` VALUES ('35', '20180821000018', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '2999.00', '1', '1', '2800', '1534847740');
INSERT INTO `es_sss_order_data` VALUES ('36', '20180821000017', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '1049.00', '1', '1', '2800', '1534847724');
INSERT INTO `es_sss_order_data` VALUES ('37', '20180821000048', '16', 'food', '18', '数码家电', 'COMPLETE', 'PAY_YES', '18447.00', '2', '6', '303', '1534849489');
INSERT INTO `es_sss_order_data` VALUES ('38', '20180821000047', '16', 'food', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '159.90', '1', '6', '303', '1534849447');
INSERT INTO `es_sss_order_data` VALUES ('39', '20180821000046', '16', 'food', '18', '数码家电', 'COMPLETE', 'PAY_YES', '6184.00', '1', '6', '303', '1534849419');
INSERT INTO `es_sss_order_data` VALUES ('40', '20180821000045', '16', 'food', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '199.00', '1', '6', '303', '1534849355');
INSERT INTO `es_sss_order_data` VALUES ('41', '20180821000044', '27', 'appliance', '16', 'superman', 'COMPLETE', 'PAY_YES', '239.90', '1', '1', '2800', '1534848960');
INSERT INTO `es_sss_order_data` VALUES ('42', '20180821000043', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '996.00', '1', '1', '2800', '1534848845');
INSERT INTO `es_sss_order_data` VALUES ('43', '20180821000042', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '59.80', '1', '1', '2800', '1534848821');
INSERT INTO `es_sss_order_data` VALUES ('44', '20180821000041', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '135.00', '1', '1', '2800', '1534848808');
INSERT INTO `es_sss_order_data` VALUES ('45', '20180821000040', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '198.00', '1', '1', '2800', '1534848801');
INSERT INTO `es_sss_order_data` VALUES ('46', '20180821000039', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '58.90', '1', '1', '2800', '1534848794');
INSERT INTO `es_sss_order_data` VALUES ('47', '20180821000038', '27', 'appliance', '16', 'superman', 'COMPLETE', 'PAY_YES', '25.99', '1', '1', '2800', '1534848783');
INSERT INTO `es_sss_order_data` VALUES ('48', '20180821000037', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '385.00', '1', '1', '2800', '1534848757');
INSERT INTO `es_sss_order_data` VALUES ('49', '20180821000054', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '4022.00', '11', '1', '72', '1534849789');
INSERT INTO `es_sss_order_data` VALUES ('50', '20180821000053', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '429.00', '1', '1', '72', '1534849757');
INSERT INTO `es_sss_order_data` VALUES ('51', '20180821000052', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '3897.00', '3', '1', '72', '1534849750');
INSERT INTO `es_sss_order_data` VALUES ('52', '20180821000050', '46', 'blue', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '15640.00', '5', '1', '72', '1534849732');
INSERT INTO `es_sss_order_data` VALUES ('53', '20180821000049', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '4788.00', '1', '1', '72', '1534849722');
INSERT INTO `es_sss_order_data` VALUES ('54', '20180821000051', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '16495.00', '5', '1', '72', '1534849741');
INSERT INTO `es_sss_order_data` VALUES ('55', '20180821000055', '27', 'appliance', '16', 'superman', 'COMPLETE', 'PAY_YES', '519.80', '2', '1', '2800', '1534854174');
INSERT INTO `es_sss_order_data` VALUES ('56', '20180821000060', '16', 'food', '16', 'superman', 'COMPLETE', 'PAY_YES', '25.99', '1', '6', '303', '1534855395');
INSERT INTO `es_sss_order_data` VALUES ('57', '20180821000061', '16', 'food', '16', 'superman', 'COMPLETE', 'PAY_YES', '25.99', '1', '6', '303', '1534855489');
INSERT INTO `es_sss_order_data` VALUES ('58', '20180821000062', '16', 'food', '16', 'superman', 'COMPLETE', 'PAY_YES', '77.97', '3', '6', '303', '1534855641');
INSERT INTO `es_sss_order_data` VALUES ('59', '20180821000063', '16', 'food', '18', '数码家电', 'PAID_OFF', 'PAY_YES', '11999.00', '1', '6', '303', '1534855784');
INSERT INTO `es_sss_order_data` VALUES ('60', '20180821000064', '16', 'food', '16', 'superman', 'COMPLETE', 'PAY_YES', '31.80', '2', '6', '303', '1534855837');
INSERT INTO `es_sss_order_data` VALUES ('61', '20180821000130', '27', 'appliance', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '642.90', '9', '1', '2800', '1534860136');
INSERT INTO `es_sss_order_data` VALUES ('62', '20180823000001', '51', 'm_18555555555', '18', '数码家电', 'COMPLETE', 'PAY_YES', '999.00', '1', '5', '274', '1535004810');
INSERT INTO `es_sss_order_data` VALUES ('63', '20180823000002', '51', 'm_18555555555', '18', '数码家电', 'COMPLETE', 'PAY_YES', '999.00', '1', '5', '274', '1535005346');
INSERT INTO `es_sss_order_data` VALUES ('64', '20180823000003', '16', 'food', '15', '食品酒水', 'COMPLETE', 'PAY_YES', '60.00', '1', '5', '142', '1535005785');
INSERT INTO `es_sss_order_data` VALUES ('65', '20180823000115', '51', 'm_18555555555', '15', '食品酒水', 'COMPLETE', 'PAY_YES', '190.40', '7', '5', '274', '1535033977');
INSERT INTO `es_sss_order_data` VALUES ('66', '20180827000002', '53', 'chopper', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '380.00', '1', '1', '72', '1535341105');
INSERT INTO `es_sss_order_data` VALUES ('67', '20180830000002', '61', 'm_13222222222', '18', '数码家电', 'COMPLETE', 'PAY_YES', '2998.00', '1', '2', '2815', '1535593961');
INSERT INTO `es_sss_order_data` VALUES ('68', '20180830000001', '61', 'm_13222222222', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '3128.00', '1', '2', '2815', '1535593896');
INSERT INTO `es_sss_order_data` VALUES ('69', '20180830000003', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3199.00', '1', '5', '274', '1535611803');
INSERT INTO `es_sss_order_data` VALUES ('72', '20181225000001', '45', 'green', '15', '食品酒水', 'ROG', 'PAY_YES', '1198.00', '2', '11', '895', '1545731924');

-- ----------------------------
-- Table structure for `es_sss_order_data_2015`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_data_2015`;
CREATE TABLE `es_sss_order_data_2015` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
  `buyer_id` int(10) DEFAULT NULL COMMENT '会员id',
  `buyer_name` varchar(255) DEFAULT NULL COMMENT '商家名称',
  `seller_id` int(10) DEFAULT NULL COMMENT '商家id',
  `seller_name` varchar(255) DEFAULT NULL COMMENT '商家名称',
  `order_status` varchar(255) DEFAULT NULL COMMENT '订单状态',
  `pay_status` varchar(255) DEFAULT NULL COMMENT '付款状态',
  `order_price` decimal(20,2) DEFAULT NULL COMMENT '订单金额',
  `goods_num` int(10) DEFAULT NULL COMMENT '订单商品数量',
  `ship_province_id` int(10) DEFAULT NULL COMMENT '省id',
  `ship_city_id` int(10) DEFAULT NULL COMMENT '市id',
  `create_time` int(12) DEFAULT NULL COMMENT '订单创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_order_data_2015
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_order_data_2017`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_data_2017`;
CREATE TABLE `es_sss_order_data_2017` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
  `buyer_id` int(10) DEFAULT NULL COMMENT '会员id',
  `buyer_name` varchar(255) DEFAULT NULL COMMENT '商家名称',
  `seller_id` int(10) DEFAULT NULL COMMENT '商家id',
  `seller_name` varchar(255) DEFAULT NULL COMMENT '商家名称',
  `order_status` varchar(255) DEFAULT NULL COMMENT '订单状态',
  `pay_status` varchar(255) DEFAULT NULL COMMENT '付款状态',
  `order_price` decimal(20,2) DEFAULT NULL COMMENT '订单金额',
  `goods_num` int(10) DEFAULT NULL COMMENT '订单商品数量',
  `ship_province_id` int(10) DEFAULT NULL COMMENT '省id',
  `ship_city_id` int(10) DEFAULT NULL COMMENT '市id',
  `create_time` int(12) DEFAULT NULL COMMENT '订单创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_order_data_2017
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_order_data_2018`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_data_2018`;
CREATE TABLE `es_sss_order_data_2018` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
  `buyer_id` int(10) DEFAULT NULL COMMENT '会员id',
  `buyer_name` varchar(255) DEFAULT NULL COMMENT '商家名称',
  `seller_id` int(10) DEFAULT NULL COMMENT '商家id',
  `seller_name` varchar(255) DEFAULT NULL COMMENT '商家名称',
  `order_status` varchar(255) DEFAULT NULL COMMENT '订单状态',
  `pay_status` varchar(255) DEFAULT NULL COMMENT '付款状态',
  `order_price` decimal(20,2) DEFAULT NULL COMMENT '订单金额',
  `goods_num` int(10) DEFAULT NULL COMMENT '订单商品数量',
  `ship_province_id` int(10) DEFAULT NULL COMMENT '省id',
  `ship_city_id` int(10) DEFAULT NULL COMMENT '市id',
  `create_time` int(12) DEFAULT NULL COMMENT '订单创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of es_sss_order_data_2018
-- ----------------------------
INSERT INTO `es_sss_order_data_2018` VALUES ('1', '20180821000016', '50', '回到过去', '1', '平台自营', 'COMPLETE', 'PAY_YES', '249.00', '3', '2', '2813', '1534847476');
INSERT INTO `es_sss_order_data_2018` VALUES ('2', '20180821000015', '50', '回到过去', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '22597.95', '7', '2', '2813', '1534847476');
INSERT INTO `es_sss_order_data_2018` VALUES ('3', '20180821000014', '50', '回到过去', '16', 'superman', 'COMPLETE', 'PAY_YES', '15.90', '1', '2', '2813', '1534847476');
INSERT INTO `es_sss_order_data_2018` VALUES ('4', '20180821000013', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '11999.00', '1', '2', '2813', '1534847476');
INSERT INTO `es_sss_order_data_2018` VALUES ('5', '20180821000012', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '11997.00', '1', '2', '2813', '1534847342');
INSERT INTO `es_sss_order_data_2018` VALUES ('6', '20180821000010', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3182.00', '1', '2', '2813', '1534847309');
INSERT INTO `es_sss_order_data_2018` VALUES ('7', '20180821000009', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '2997.00', '1', '2', '2813', '1534847294');
INSERT INTO `es_sss_order_data_2018` VALUES ('8', '20180821000011', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '6486.00', '1', '2', '2813', '1534847327');
INSERT INTO `es_sss_order_data_2018` VALUES ('9', '20180821000007', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3697.00', '1', '2', '2813', '1534847262');
INSERT INTO `es_sss_order_data_2018` VALUES ('10', '20180821000008', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '1199.00', '1', '2', '2813', '1534847277');
INSERT INTO `es_sss_order_data_2018` VALUES ('11', '20180821000001', '16', 'food', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '67.32', '1', '6', '303', '1534846758');
INSERT INTO `es_sss_order_data_2018` VALUES ('12', '20180821000002', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '6099.00', '1', '2', '2813', '1534847172');
INSERT INTO `es_sss_order_data_2018` VALUES ('13', '20180821000003', '50', '回到过去', '18', '数码家电', 'COMPLETE', 'PAY_YES', '1596.00', '1', '2', '2813', '1534847204');
INSERT INTO `es_sss_order_data_2018` VALUES ('14', '20180821000004', '50', '回到过去', '1', '平台自营', 'COMPLETE', 'PAY_YES', '2299.00', '1', '2', '2813', '1534847216');
INSERT INTO `es_sss_order_data_2018` VALUES ('15', '20180821000005', '50', '回到过去', '1', '平台自营', 'COMPLETE', 'PAY_YES', '189.00', '1', '2', '2813', '1534847228');
INSERT INTO `es_sss_order_data_2018` VALUES ('16', '20180821000006', '50', '回到过去', '1', '平台自营', 'COMPLETE', 'PAY_YES', '2299.00', '1', '2', '2813', '1534847240');
INSERT INTO `es_sss_order_data_2018` VALUES ('17', '20180821000036', '27', 'appliance', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '4556.90', '4', '1', '2800', '1534848112');
INSERT INTO `es_sss_order_data_2018` VALUES ('18', '20180821000034', '27', 'appliance', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '1778.00', '2', '1', '2800', '1534848112');
INSERT INTO `es_sss_order_data_2018` VALUES ('19', '20180821000035', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '62861.00', '6', '1', '2800', '1534848112');
INSERT INTO `es_sss_order_data_2018` VALUES ('20', '20180821000033', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '19337.00', '2', '1', '2800', '1534847978');
INSERT INTO `es_sss_order_data_2018` VALUES ('21', '20180821000032', '27', 'appliance', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '249.00', '1', '1', '2800', '1534847964');
INSERT INTO `es_sss_order_data_2018` VALUES ('22', '20180821000031', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '4799.00', '1', '1', '2800', '1534847947');
INSERT INTO `es_sss_order_data_2018` VALUES ('23', '20180821000030', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '1778.00', '2', '1', '2800', '1534847947');
INSERT INTO `es_sss_order_data_2018` VALUES ('24', '20180821000028', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3699.00', '1', '1', '2800', '1534847900');
INSERT INTO `es_sss_order_data_2018` VALUES ('25', '20180821000025', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '399.00', '1', '1', '2800', '1534847855');
INSERT INTO `es_sss_order_data_2018` VALUES ('26', '20180821000021', '27', 'appliance', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '2599.00', '1', '1', '2800', '1534847789');
INSERT INTO `es_sss_order_data_2018` VALUES ('27', '20180821000027', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '1738.00', '1', '1', '2800', '1534847888');
INSERT INTO `es_sss_order_data_2018` VALUES ('28', '20180821000029', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '120.00', '1', '1', '2800', '1534847921');
INSERT INTO `es_sss_order_data_2018` VALUES ('29', '20180821000024', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '6798.00', '2', '1', '2800', '1534847855');
INSERT INTO `es_sss_order_data_2018` VALUES ('30', '20180821000022', '27', 'appliance', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '4198.00', '2', '1', '2800', '1534847803');
INSERT INTO `es_sss_order_data_2018` VALUES ('31', '20180821000023', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '399.00', '1', '1', '2800', '1534847828');
INSERT INTO `es_sss_order_data_2018` VALUES ('32', '20180821000020', '27', 'appliance', '1', '平台自营', 'COMPLETE', 'PAY_YES', '1299.00', '1', '1', '2800', '1534847756');
INSERT INTO `es_sss_order_data_2018` VALUES ('33', '20180821000019', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3699.00', '1', '1', '2800', '1534847748');
INSERT INTO `es_sss_order_data_2018` VALUES ('34', '20180821000026', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '10198.00', '2', '1', '2800', '1534847874');
INSERT INTO `es_sss_order_data_2018` VALUES ('35', '20180821000018', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '2999.00', '1', '1', '2800', '1534847740');
INSERT INTO `es_sss_order_data_2018` VALUES ('36', '20180821000017', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '1049.00', '1', '1', '2800', '1534847724');
INSERT INTO `es_sss_order_data_2018` VALUES ('37', '20180821000048', '16', 'food', '18', '数码家电', 'COMPLETE', 'PAY_YES', '18447.00', '2', '6', '303', '1534849489');
INSERT INTO `es_sss_order_data_2018` VALUES ('38', '20180821000047', '16', 'food', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '159.90', '1', '6', '303', '1534849447');
INSERT INTO `es_sss_order_data_2018` VALUES ('39', '20180821000046', '16', 'food', '18', '数码家电', 'COMPLETE', 'PAY_YES', '6184.00', '1', '6', '303', '1534849419');
INSERT INTO `es_sss_order_data_2018` VALUES ('40', '20180821000045', '16', 'food', '17', '化妆品店铺', 'COMPLETE', 'PAY_YES', '199.00', '1', '6', '303', '1534849355');
INSERT INTO `es_sss_order_data_2018` VALUES ('41', '20180821000044', '27', 'appliance', '16', 'superman', 'COMPLETE', 'PAY_YES', '239.90', '1', '1', '2800', '1534848960');
INSERT INTO `es_sss_order_data_2018` VALUES ('42', '20180821000043', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '996.00', '1', '1', '2800', '1534848845');
INSERT INTO `es_sss_order_data_2018` VALUES ('43', '20180821000042', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '59.80', '1', '1', '2800', '1534848821');
INSERT INTO `es_sss_order_data_2018` VALUES ('44', '20180821000041', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '135.00', '1', '1', '2800', '1534848808');
INSERT INTO `es_sss_order_data_2018` VALUES ('45', '20180821000040', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '198.00', '1', '1', '2800', '1534848801');
INSERT INTO `es_sss_order_data_2018` VALUES ('46', '20180821000039', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '58.90', '1', '1', '2800', '1534848794');
INSERT INTO `es_sss_order_data_2018` VALUES ('47', '20180821000038', '27', 'appliance', '16', 'superman', 'COMPLETE', 'PAY_YES', '25.99', '1', '1', '2800', '1534848783');
INSERT INTO `es_sss_order_data_2018` VALUES ('48', '20180821000037', '27', 'appliance', '10', '母婴和玩具', 'COMPLETE', 'PAY_YES', '385.00', '1', '1', '2800', '1534848757');
INSERT INTO `es_sss_order_data_2018` VALUES ('49', '20180821000054', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '4022.00', '11', '1', '72', '1534849789');
INSERT INTO `es_sss_order_data_2018` VALUES ('50', '20180821000053', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '429.00', '1', '1', '72', '1534849757');
INSERT INTO `es_sss_order_data_2018` VALUES ('51', '20180821000052', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '3897.00', '3', '1', '72', '1534849750');
INSERT INTO `es_sss_order_data_2018` VALUES ('52', '20180821000050', '46', 'blue', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '15640.00', '5', '1', '72', '1534849732');
INSERT INTO `es_sss_order_data_2018` VALUES ('53', '20180821000049', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '4788.00', '1', '1', '72', '1534849722');
INSERT INTO `es_sss_order_data_2018` VALUES ('54', '20180821000051', '46', 'blue', '1', '平台自营', 'COMPLETE', 'PAY_YES', '16495.00', '5', '1', '72', '1534849741');
INSERT INTO `es_sss_order_data_2018` VALUES ('55', '20180821000055', '27', 'appliance', '16', 'superman', 'COMPLETE', 'PAY_YES', '519.80', '2', '1', '2800', '1534854174');
INSERT INTO `es_sss_order_data_2018` VALUES ('56', '20180821000060', '16', 'food', '16', 'superman', 'COMPLETE', 'PAY_YES', '25.99', '1', '6', '303', '1534855395');
INSERT INTO `es_sss_order_data_2018` VALUES ('57', '20180821000061', '16', 'food', '16', 'superman', 'COMPLETE', 'PAY_YES', '25.99', '1', '6', '303', '1534855489');
INSERT INTO `es_sss_order_data_2018` VALUES ('58', '20180821000062', '16', 'food', '16', 'superman', 'COMPLETE', 'PAY_YES', '77.97', '3', '6', '303', '1534855641');
INSERT INTO `es_sss_order_data_2018` VALUES ('59', '20180821000063', '16', 'food', '18', '数码家电', 'PAID_OFF', 'PAY_YES', '11999.00', '1', '6', '303', '1534855784');
INSERT INTO `es_sss_order_data_2018` VALUES ('60', '20180821000064', '16', 'food', '16', 'superman', 'COMPLETE', 'PAY_YES', '31.80', '2', '6', '303', '1534855837');
INSERT INTO `es_sss_order_data_2018` VALUES ('61', '20180821000130', '27', 'appliance', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '642.90', '9', '1', '2800', '1534860136');
INSERT INTO `es_sss_order_data_2018` VALUES ('62', '20180823000001', '51', 'm_18555555555', '18', '数码家电', 'COMPLETE', 'PAY_YES', '999.00', '1', '5', '274', '1535004810');
INSERT INTO `es_sss_order_data_2018` VALUES ('63', '20180823000002', '51', 'm_18555555555', '18', '数码家电', 'COMPLETE', 'PAY_YES', '999.00', '1', '5', '274', '1535005346');
INSERT INTO `es_sss_order_data_2018` VALUES ('64', '20180823000003', '16', 'food', '15', '食品酒水', 'COMPLETE', 'PAY_YES', '60.00', '1', '5', '142', '1535005785');
INSERT INTO `es_sss_order_data_2018` VALUES ('65', '20180823000115', '51', 'm_18555555555', '15', '食品酒水', 'COMPLETE', 'PAY_YES', '190.40', '7', '5', '274', '1535033977');
INSERT INTO `es_sss_order_data_2018` VALUES ('66', '20180827000002', '53', 'chopper', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '380.00', '1', '1', '72', '1535341105');
INSERT INTO `es_sss_order_data_2018` VALUES ('67', '20180830000002', '61', 'm_13222222222', '18', '数码家电', 'COMPLETE', 'PAY_YES', '2998.00', '1', '2', '2815', '1535593961');
INSERT INTO `es_sss_order_data_2018` VALUES ('68', '20180830000001', '61', 'm_13222222222', '1', '平台自营', 'PAID_OFF', 'PAY_YES', '3128.00', '1', '2', '2815', '1535593896');
INSERT INTO `es_sss_order_data_2018` VALUES ('69', '20180830000003', '27', 'appliance', '18', '数码家电', 'COMPLETE', 'PAY_YES', '3199.00', '1', '5', '274', '1535611803');

-- ----------------------------
-- Table structure for `es_sss_order_data_2019`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_data_2019`;
CREATE TABLE `es_sss_order_data_2019` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sn` varchar(255) DEFAULT NULL,
  `buyer_id` int(10) DEFAULT NULL,
  `buyer_name` varchar(255) DEFAULT NULL,
  `seller_id` int(10) DEFAULT NULL,
  `seller_name` char(10) DEFAULT NULL,
  `order_status` varchar(255) DEFAULT NULL,
  `pay_status` varchar(255) DEFAULT NULL,
  `order_price` decimal(20,2) DEFAULT NULL,
  `goods_num` int(10) DEFAULT NULL,
  `ship_province_id` int(10) DEFAULT NULL,
  `ship_city_id` int(10) DEFAULT NULL,
  `create_time` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `es_sss_order_goods_data`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_goods_data`;
CREATE TABLE `es_sss_order_goods_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
  `goods_id` int(10) DEFAULT NULL COMMENT '商品id',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `goods_num` int(10) DEFAULT NULL COMMENT '数量',
  `price` decimal(20,2) DEFAULT NULL COMMENT '商品单价',
  `sub_total` decimal(20,2) DEFAULT NULL COMMENT '小计',
  `category_path` varchar(255) DEFAULT NULL COMMENT '分类path',
  `category_id` int(10) DEFAULT NULL COMMENT '分类id',
  `create_time` int(12) DEFAULT NULL COMMENT '创建时间',
  `industry_id` bigint(10) DEFAULT NULL COMMENT '行业id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='订单商品表(es_sss_order_goods_data)';

-- ----------------------------
-- Records of es_sss_order_goods_data
-- ----------------------------
INSERT INTO `es_sss_order_goods_data` VALUES ('1', '20180821000016', '292', '【内蒙古乌兰察布】草原星 内蒙特产牛肉干手撕500g实惠装 香辣味', '1', '0.00', '0.00', '0|1|2|306|', '306', '1534847476', '306');
INSERT INTO `es_sss_order_goods_data` VALUES ('2', '20180821000016', '285', '【三只松鼠_碧根果210gx2袋】零食坚果炒货山核桃长寿果干果奶油味 奶油口味', '1', '0.00', '0.00', '0|1|2|6|', '6', '1534847476', '6');
INSERT INTO `es_sss_order_goods_data` VALUES ('3', '20180821000016', '184', '罗技（Logitech）G402 高速追踪游戏鼠标 吃鸡鼠标', '1', '173.33', '173.33', '0|491|502|505|', '505', '1534847476', '505');
INSERT INTO `es_sss_order_goods_data` VALUES ('4', '20180821000015', '49', '百雀羚小森羚温和净颜卸妆水脸部眼唇卸妆液清洁毛孔不油腻', '1', '1599.00', '1599.00', '0|1|18|21|', '21', '1534847476', '21');
INSERT INTO `es_sss_order_goods_data` VALUES ('5', '20180821000015', '51', '佳雪芦荟保湿霜3瓶量贩套装国货护肤品芦荟胶滋润补水面霜', '1', '5999.00', '5999.00', '0|1|18|19|', '19', '1534847476', '19');
INSERT INTO `es_sss_order_goods_data` VALUES ('6', '20180821000015', '50', '百雀羚小森羚海棠身体乳润肤乳保湿滋润补水淡香润体乳学生少女', '5', '2999.99', '14999.95', '0|1|18|19|', '19', '1534847476', '19');
INSERT INTO `es_sss_order_goods_data` VALUES ('7', '20180821000014', '27', '纺布者潮牌大码卫衣男加肥加大秋季新款男士长袖胖子时尚宽松上衣', '1', '15.90', '15.90', '0|1|2|', '2', '1534847476', '2');
INSERT INTO `es_sss_order_goods_data` VALUES ('8', '20180821000013', '173', '未来人类(Terrans Force)S4-1060-67S', '1', '11999.00', '11999.00', '0|491|492|494|', '494', '1534847476', '494');
INSERT INTO `es_sss_order_goods_data` VALUES ('9', '20180821000012', '173', '未来人类(Terrans Force)S4-1060-67S', '1', '11997.00', '11997.00', '0|491|492|494|', '494', '1534847342', '494');
INSERT INTO `es_sss_order_goods_data` VALUES ('10', '20180821000010', '183', '锤子M1L白色-6G+64GB移动联通电信全网通公开版', '1', '3182.00', '3182.00', '0|491|492|497|', '497', '1534847309', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('11', '20180821000009', '185', '锤子M1-咖啡金-4G+32GB 移动联通电信全网通', '1', '2997.00', '2997.00', '0|491|492|497|', '497', '1534847294', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('12', '20180821000011', '177', 'Apple iPhone 7 Plus 128GB 玫瑰金色', '1', '6486.00', '6486.00', '0|491|492|497|', '497', '1534847327', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('13', '20180821000007', '193', '海尔（Haier）BCD-310WDPF 310升多门冰箱 ', '1', '3697.00', '3697.00', '0|491|493|495|', '495', '1534847262', '495');
INSERT INTO `es_sss_order_goods_data` VALUES ('14', '20180821000008', '186', '红米Note 4 高配全网通版 3GB内存 64GB 金色', '1', '1199.00', '1199.00', '0|491|492|497|', '497', '1534847277', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('15', '20180821000001', '107', '儿童电动车摇摆童车四轮室内车带遥控玩具车可坐人摩托车电动汽车', '1', '67.32', '67.32', '0|56|66|69|', '69', '1534846758', '69');
INSERT INTO `es_sss_order_goods_data` VALUES ('16', '20180821000002', '303', '戴尔（DELL）灵越 13-7370-R1505S 13.3英寸轻薄笔记本电脑（i5-8250U 8G 128G', '1', '6099.00', '6099.00', '0|491|492|494|', '494', '1534847172', '494');
INSERT INTO `es_sss_order_goods_data` VALUES ('17', '20180821000003', '178', 'HUAWEI nova（3GB+32GB）CAZ-TL10 ', '1', '1596.00', '1596.00', '0|491|492|497|', '497', '1534847204', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('18', '20180821000004', '224', '美的（Midea）嵌入式微波炉 TG025QPS-NSH 2', '1', '2299.00', '2299.00', '0|491|500|511|', '511', '1534847216', '511');
INSERT INTO `es_sss_order_goods_data` VALUES ('19', '20180821000005', '175', '美的(Midea)WFS3018Q智能可预约电饭煲 3升/3', '1', '189.00', '189.00', '0|491|500|501|', '501', '1534847228', '501');
INSERT INTO `es_sss_order_goods_data` VALUES ('20', '20180821000006', '224', '美的（Midea）嵌入式微波炉 TG025QPS-NSH 2', '1', '2299.00', '2299.00', '0|491|500|511|', '511', '1534847240', '511');
INSERT INTO `es_sss_order_goods_data` VALUES ('21', '20180821000036', '49', '百雀羚小森羚温和净颜卸妆水脸部眼唇卸妆液清洁毛孔不油腻', '1', '1599.00', '1599.00', '0|1|18|21|', '21', '1534848112', '21');
INSERT INTO `es_sss_order_goods_data` VALUES ('22', '20180821000036', '48', '百雀羚三生花舒缓细肤柔润凝乳精华乳液女补水保湿学生', '1', '2599.00', '2599.00', '0|1|18|168|', '168', '1534848112', '168');
INSERT INTO `es_sss_order_goods_data` VALUES ('23', '20180821000036', '63', 'LA MER海蓝之谜赋活保湿精华露30ml 水润保湿 润泽', '1', '199.00', '199.00', '0|38|39|385|', '385', '1534848112', '385');
INSERT INTO `es_sss_order_goods_data` VALUES ('24', '20180821000036', '65', '兰蔻 黑金臻宠精华乳30ml 柔软平滑紧致光泽 淡细纹补水保湿滋润', '1', '159.90', '159.90', '0|38|39|385|', '385', '1534848112', '385');
INSERT INTO `es_sss_order_goods_data` VALUES ('25', '20180821000034', '229', 'Razer雷蛇 黑寡妇蜘蛛V2幻彩版 lol电竞游戏机械键盘', '1', '1079.00', '1079.00', '0|491|502|506|', '506', '1534848112', '506');
INSERT INTO `es_sss_order_goods_data` VALUES ('26', '20180821000034', '227', '樱桃（Cherry）机械键盘G80-3000LSCEU-0白', '1', '699.00', '699.00', '0|491|502|506|', '506', '1534848112', '506');
INSERT INTO `es_sss_order_goods_data` VALUES ('27', '20180821000035', '302', 'honor荣耀畅玩7X尊享版 4GB+128GB 铂光金 移动联通电信4G手机', '1', '1999.00', '1999.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('28', '20180821000035', '283', '未来人类(Terrans Force) X911-1080S-77X 桌面级i7-7700K 双GTX1080显卡 新', '1', '39888.00', '39888.00', '0|491|492|494|', '494', '1534848112', '494');
INSERT INTO `es_sss_order_goods_data` VALUES ('29', '20180821000035', '234', '三星 Galaxy S8 Plus S8+（G9550）6G', '1', '7288.00', '7288.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('30', '20180821000035', '298', 'Apple iPhone 8 Plus 64GB 金色 移动联通电信4G手机', '1', '6688.00', '6688.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('31', '20180821000035', '299', '三星 Galaxy S7 edge（G9350）4+64G版 铂光金 全网通', '1', '3299.00', '3299.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('32', '20180821000035', '226', 'OPPO R11 Plus 6GB+64GB 玫瑰金', '1', '3699.00', '3699.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('33', '20180821000033', '234', '三星 Galaxy S8 Plus S8+（G9550）6G', '1', '7288.00', '7288.00', '0|491|492|497|', '497', '1534847978', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('34', '20180821000033', '236', ' 三星手机SM-W2017', '1', '12049.00', '12049.00', '0|491|492|497|', '497', '1534847978', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('35', '20180821000032', '238', '小米路由器3G 双千兆光纤宽带穿墙王 高增益四天线 散热好 ', '1', '249.00', '249.00', '0|491|502|508|', '508', '1534847964', '508');
INSERT INTO `es_sss_order_goods_data` VALUES ('36', '20180821000031', '232', ' 小米6 全网通 6GB+128GB 探索银限量版', '1', '4799.00', '4799.00', '0|491|492|497|', '497', '1534847947', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('37', '20180821000030', '229', 'Razer雷蛇 黑寡妇蜘蛛V2幻彩版 lol电竞游戏机械键盘', '1', '1079.00', '1079.00', '0|491|502|506|', '506', '1534847947', '506');
INSERT INTO `es_sss_order_goods_data` VALUES ('38', '20180821000030', '227', '樱桃（Cherry）机械键盘G80-3000LSCEU-0白', '1', '699.00', '699.00', '0|491|502|506|', '506', '1534847947', '506');
INSERT INTO `es_sss_order_goods_data` VALUES ('39', '20180821000028', '226', 'OPPO R11 Plus 6GB+64GB 玫瑰金', '1', '3699.00', '3699.00', '0|491|492|497|', '497', '1534847900', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('40', '20180821000025', '203', '小米（MI）米家IH电饭煲 智能电饭煲 IH电磁环绕加热 手', '1', '399.00', '399.00', '0|491|500|501|', '501', '1534847855', '501');
INSERT INTO `es_sss_order_goods_data` VALUES ('41', '20180821000021', '48', '百雀羚三生花舒缓细肤柔润凝乳精华乳液女补水保湿学生', '1', '2599.00', '2599.00', '0|1|18|168|', '168', '1534847789', '168');
INSERT INTO `es_sss_order_goods_data` VALUES ('42', '20180821000027', '211', '三洋（SANYO）WF810326BS0S 8公斤', '1', '1738.00', '1738.00', '0|491|493|498|', '498', '1534847888', '498');
INSERT INTO `es_sss_order_goods_data` VALUES ('43', '20180821000029', '230', '小米（MI）小米便携鼠标 智能轻薄便携 无线+蓝牙双连接 家', '1', '120.00', '120.00', '0|491|502|505|', '505', '1534847921', '505');
INSERT INTO `es_sss_order_goods_data` VALUES ('44', '20180821000024', '200', '创维(Skyworth) 55M7 55英寸', '1', '2799.00', '2799.00', '0|491|493|496|', '496', '1534847855', '496');
INSERT INTO `es_sss_order_goods_data` VALUES ('45', '20180821000024', '199', 'TCL D55A620U 55英寸 观影王4K版', '1', '3999.00', '3999.00', '0|491|493|496|', '496', '1534847855', '496');
INSERT INTO `es_sss_order_goods_data` VALUES ('46', '20180821000022', '48', '百雀羚三生花舒缓细肤柔润凝乳精华乳液女补水保湿学生', '1', '2599.00', '2599.00', '0|1|18|168|', '168', '1534847803', '168');
INSERT INTO `es_sss_order_goods_data` VALUES ('47', '20180821000022', '49', '百雀羚小森羚温和净颜卸妆水脸部眼唇卸妆液清洁毛孔不油腻', '1', '1599.00', '1599.00', '0|1|18|21|', '21', '1534847803', '21');
INSERT INTO `es_sss_order_goods_data` VALUES ('48', '20180821000023', '203', '小米（MI）米家IH电饭煲 智能电饭煲 IH电磁环绕加热 手', '1', '399.00', '399.00', '0|491|500|501|', '501', '1534847828', '501');
INSERT INTO `es_sss_order_goods_data` VALUES ('49', '20180821000020', '195', '华硕（ASUS）Spatha ROG玩家国度 游戏鼠标', '1', '1299.00', '1299.00', '0|491|502|505|', '505', '1534847756', '505');
INSERT INTO `es_sss_order_goods_data` VALUES ('50', '20180821000019', '193', '海尔（Haier）BCD-310WDPF 310升多门冰箱 ', '1', '3699.00', '3699.00', '0|491|493|495|', '495', '1534847748', '495');
INSERT INTO `es_sss_order_goods_data` VALUES ('51', '20180821000026', '209', '索尼(SONY)KDL-48W650D 48英寸 全高清LE', '1', '3199.00', '3199.00', '0|491|493|496|', '496', '1534847874', '496');
INSERT INTO `es_sss_order_goods_data` VALUES ('52', '20180821000026', '208', '索尼(SONY)KD-55X8500D 55英寸 ', '1', '6999.00', '6999.00', '0|491|493|496|', '496', '1534847874', '496');
INSERT INTO `es_sss_order_goods_data` VALUES ('53', '20180821000018', '197', '美菱(MELING) BCD-551WPCX 551升', '1', '2999.00', '2999.00', '0|491|493|495|', '495', '1534847740', '495');
INSERT INTO `es_sss_order_goods_data` VALUES ('54', '20180821000017', '191', '魅族 魅蓝note5 4G+全网通版 灰色 移动联通电信4G', '1', '1049.00', '1049.00', '0|491|492|497|', '497', '1534847724', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('55', '20180821000048', '173', '未来人类(Terrans Force)S4-1060-67S', '1', '11999.00', '11999.00', '0|491|492|494|', '494', '1534849489', '494');
INSERT INTO `es_sss_order_goods_data` VALUES ('56', '20180821000048', '174', 'Apple iPhone 7 Plus 128GB 亮黑色 ', '1', '6448.00', '6448.00', '0|491|492|497|', '497', '1534849489', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('57', '20180821000047', '65', '兰蔻 黑金臻宠精华乳30ml 柔软平滑紧致光泽 淡细纹补水保湿滋润', '1', '159.90', '159.90', '0|38|39|385|', '385', '1534849447', '385');
INSERT INTO `es_sss_order_goods_data` VALUES ('58', '20180821000046', '172', '联想（Lenovo）Y50p-70 15.6英寸游戏笔记本', '1', '6184.00', '6184.00', '0|491|492|494|', '494', '1534849419', '494');
INSERT INTO `es_sss_order_goods_data` VALUES ('59', '20180821000045', '63', 'LA MER海蓝之谜赋活保湿精华露30ml 水润保湿 润泽', '1', '199.00', '199.00', '0|38|39|385|', '385', '1534849355', '385');
INSERT INTO `es_sss_order_goods_data` VALUES ('60', '20180821000044', '35', '唐狮秋冬季情侣装毛衣男女韩版图案小清新圆领套头学生针织衫', '1', '239.90', '239.90', '0|79|', '79', '1534848960', '79');
INSERT INTO `es_sss_order_goods_data` VALUES ('61', '20180821000043', '121', '童装男童秋冬装套装2018新款儿童加绒加厚金丝绒卫衣三件套中大童', '1', '996.00', '996.00', '0|56|200|205|', '205', '1534848845', '205');
INSERT INTO `es_sss_order_goods_data` VALUES ('62', '20180821000042', '111', '亿宝莱高景观婴儿推车可坐可躺轻便携式折叠小孩宝宝双向婴儿童车', '1', '59.80', '59.80', '0|56|71|73|', '73', '1534848821', '73');
INSERT INTO `es_sss_order_goods_data` VALUES ('63', '20180821000041', '109', '大型儿童电动车四轮卡丁车小孩玩具汽车宝宝遥控可坐人童车', '1', '135.00', '135.00', '0|56|66|426|', '426', '1534848808', '426');
INSERT INTO `es_sss_order_goods_data` VALUES ('64', '20180821000040', '110', '米兔故事机mini儿童早教机宝宝婴儿幼儿玩具学习机', '1', '198.00', '198.00', '0|56|71|72|', '72', '1534848801', '72');
INSERT INTO `es_sss_order_goods_data` VALUES ('65', '20180821000039', '104', '双鹰遥控搅拌车工程车电动玩具水泥车混凝土罐车汽车模型儿童男孩', '1', '58.90', '58.90', '0|56|62|64|', '64', '1534848794', '64');
INSERT INTO `es_sss_order_goods_data` VALUES ('66', '20180821000038', '22', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '1', '25.99', '25.99', '0|56|57|', '57', '1534848783', '57');
INSERT INTO `es_sss_order_goods_data` VALUES ('67', '20180821000037', '101', '亲子装2017新款秋冬季母女装针织衫韩版宽松外穿毛衣纯色打底春装', '1', '385.00', '385.00', '0|56|57|58|', '58', '1534848757', '58');
INSERT INTO `es_sss_order_goods_data` VALUES ('68', '20180821000054', '269', '索尼（SONY）PlayStation4游戏手柄 新款PS4无线控制器（蓝色）', '10', '380.00', '3800.00', '0|491|503|521|', '521', '1534849789', '521');
INSERT INTO `es_sss_order_goods_data` VALUES ('69', '20180821000054', '273', '索尼（SONY）PS4 Slim Pro 正版游戏软件 实体光盘 GTA5 猎车手5', '1', '222.00', '222.00', '0|491|503|522|', '522', '1534849789', '522');
INSERT INTO `es_sss_order_goods_data` VALUES ('70', '20180821000053', '268', '微软（Microsoft) Xbox 无线控制器 （蓝牙连接 带3.5mm的耳机接头 白色）', '1', '429.00', '429.00', '0|491|503|521|', '521', '1534849757', '521');
INSERT INTO `es_sss_order_goods_data` VALUES ('71', '20180821000052', '265', '索尼（SONY）【PS4 官方配件】PS4 slim /PSV/PS4 Pro7.1声道 白金版无线头戴耳机', '3', '1299.00', '3897.00', '0|491|503|520|', '520', '1534849750', '520');
INSERT INTO `es_sss_order_goods_data` VALUES ('72', '20180821000050', '260', '任天堂 Nintendo switch掌上游戏机便携式掌机Switch NS主机（红蓝手柄）+塞尔达', '5', '3128.00', '15640.00', '0|491|503|519|', '519', '1534849732', '519');
INSERT INTO `es_sss_order_goods_data` VALUES ('73', '20180821000049', '258', 'Xbox One S 1TB双手柄竞技版 含体感器及三国志、最终幻想等11款游戏', '1', '4788.00', '4788.00', '0|491|503|519|', '519', '1534849722', '519');
INSERT INTO `es_sss_order_goods_data` VALUES ('74', '20180821000051', '261', '索尼 Sony PlayStation 4 PS4 Pro 国行游戏主机 HDR色彩 支持4K 1TB容量 黑色', '5', '3299.00', '16495.00', '0|491|503|519|', '519', '1534849741', '519');
INSERT INTO `es_sss_order_goods_data` VALUES ('75', '20180821000055', '35', '唐狮秋冬季情侣装毛衣男女韩版图案小清新圆领套头学生针织衫', '2', '259.90', '519.80', '0|79|', '79', '1534854174', '79');
INSERT INTO `es_sss_order_goods_data` VALUES ('76', '20180821000060', '22', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '1', '25.99', '25.99', '0|56|57|', '57', '1534855395', '57');
INSERT INTO `es_sss_order_goods_data` VALUES ('77', '20180821000061', '22', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '1', '25.99', '25.99', '0|56|57|', '57', '1534855489', '57');
INSERT INTO `es_sss_order_goods_data` VALUES ('78', '20180821000062', '22', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '3', '25.99', '77.97', '0|56|57|', '57', '1534855641', '57');
INSERT INTO `es_sss_order_goods_data` VALUES ('79', '20180821000063', '173', '未来人类(Terrans Force)S4-1060-67S', '1', '11999.00', '11999.00', '0|491|492|494|', '494', '1534855784', '494');
INSERT INTO `es_sss_order_goods_data` VALUES ('80', '20180821000064', '27', '纺布者潮牌大码卫衣男加肥加大秋季新款男士长袖胖子时尚宽松上衣', '2', '15.90', '31.80', '0|1|2|', '2', '1534855837', '2');
INSERT INTO `es_sss_order_goods_data` VALUES ('81', '20180821000130', '331', '东道 汝窑坐禅茶组 汝窑茶具套装开片汝瓷功夫整套茶具 坐禅小茶组一壶三杯-天青', '2', '20.00', '40.00', '0|79|130|131|', '131', '1534860136', '131');
INSERT INTO `es_sss_order_goods_data` VALUES ('82', '20180821000130', '333', '张小泉 (Zhang Xiao Quan) NS-7 合金指甲剪修甲剪刀脚趾剪子', '2', '12.00', '24.00', '0|79|219|221|', '221', '1534860136', '221');
INSERT INTO `es_sss_order_goods_data` VALUES ('83', '20180821000130', '334', 'LANCOME 兰蔻清滢保湿柔肤水大粉水400ml爽肤水女补水保湿补水滋润营养正品大瓶装 法国进口【最新版本】', '1', '309.00', '309.00', '0|38|39|383|', '383', '1534860136', '383');
INSERT INTO `es_sss_order_goods_data` VALUES ('84', '20180821000130', '329', '富光（FUGUANG) 玻璃杯WFB1020-500 500ml男女士带茶隔 便携创意双层泡茶玻璃水杯 500ml', '1', '10.00', '10.00', '0|79|124|125|', '125', '1534860136', '125');
INSERT INTO `es_sss_order_goods_data` VALUES ('85', '20180821000130', '330', '乐扣乐扣（lock&lock）塑料杯 杯子水杯 随手杯 470ML HPL931', '1', '11.90', '11.90', '0|79|124|126|', '126', '1534860136', '126');
INSERT INTO `es_sss_order_goods_data` VALUES ('86', '20180821000130', '328', '苏泊尔（SUPOR）炒锅NC32F4易洁不粘锅 32cm 少油烟 送原装木铲', '1', '169.00', '169.00', '0|79|80|83|', '83', '1534860136', '83');
INSERT INTO `es_sss_order_goods_data` VALUES ('87', '20180821000130', '326', '美的（Midea）电水壶 WSJ1702b 1.7L 优质温控器 食品级304不锈钢 电热水瓶 电热水壶 电水壶', '1', '79.00', '79.00', '0|79|80|82|', '82', '1534860136', '82');
INSERT INTO `es_sss_order_goods_data` VALUES ('88', '20180823000001', '259', 'honor荣耀V9 play标配版 3GB+32GB 幻夜黑', '1', '999.00', '999.00', '0|491|492|497|', '497', '1535004810', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('89', '20180823000002', '259', 'honor荣耀V9 play标配版 3GB+32GB 幻夜黑', '1', '999.00', '999.00', '0|491|492|497|', '497', '1535005346', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('90', '20180823000003', '321', '促销商品J', '1', '50.00', '50.00', '0|1|2|7|', '7', '1535005785', '7');
INSERT INTO `es_sss_order_goods_data` VALUES ('91', '20180823000115', '1', '百草味菠萝干100g 菠萝块凤梨干/片蜜饯水果干小吃', '6', '25.90', '155.40', '0|1|13|14|', '14', '1535033977', '14');
INSERT INTO `es_sss_order_goods_data` VALUES ('92', '20180823000115', '315', '促销商品D', '1', '35.00', '35.00', '0|1|2|7|', '7', '1535033977', '7');
INSERT INTO `es_sss_order_goods_data` VALUES ('93', '20180827000002', '269', '索尼（SONY）PlayStation4游戏手柄 新款PS4无线控制器（蓝色）', '1', '380.00', '380.00', '0|491|503|521|', '521', '1535341105', '521');
INSERT INTO `es_sss_order_goods_data` VALUES ('94', '20180830000002', '264', 'vivo X20 4GB+64GB 磨砂黑 移动联通电信4G手机 全面屏拍照 面部识别', '1', '2998.00', '2998.00', '0|491|492|497|', '497', '1535593961', '497');
INSERT INTO `es_sss_order_goods_data` VALUES ('95', '20180830000001', '260', '任天堂 Nintendo switch掌上游戏机便携式掌机Switch NS主机（红蓝手柄）+塞尔达', '1', '3128.00', '3128.00', '0|491|503|519|', '519', '1535593896', '519');
INSERT INTO `es_sss_order_goods_data` VALUES ('96', '20180830000003', '209', '索尼(SONY)KDL-48W650D 48英寸 全高清LE', '1', '3199.00', '3199.00', '0|491|493|496|', '496', '1535611803', '496');
INSERT INTO `es_sss_order_goods_data` VALUES ('97', '20180901000001', '284', '九阳（Joyoung）电饭煲 JYF-30FE09 3升 多功能 7段智能温控 黄晶内胆 电饭锅', '1', '0.00', '0.00', '0|491|500|501|', '501', '1535812987', '501');
INSERT INTO `es_sss_order_goods_data` VALUES ('98', '20180901000003', '333', '张小泉 (Zhang Xiao Quan) NS-7 合金指甲剪修甲剪刀脚趾剪子', '1', '9.00', '9.00', '0|79|219|221|', '221', '1535815229', '221');
INSERT INTO `es_sss_order_goods_data` VALUES ('99', '20181225000001', '16', '熊孩子 综合水果干108gx2袋混合装果干什锦脱水蔬果脆片休闲零食', '2', '599.00', '1198.00', '0|35|160|164|', '164', '1545731924', '35');

-- ----------------------------
-- Table structure for `es_sss_order_goods_data_2015`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_goods_data_2015`;
CREATE TABLE `es_sss_order_goods_data_2015` (
  `id` int(11) NOT NULL DEFAULT '0',
  `order_sn` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `goods_id` int(10) DEFAULT NULL,
  `goods_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `goods_num` int(10) DEFAULT NULL,
  `price` decimal(20,2) DEFAULT NULL,
  `sub_total` decimal(20,2) DEFAULT NULL,
  `category_path` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `category_id` int(10) DEFAULT '0',
  `create_time` int(12) DEFAULT '0',
  `industry_id` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_order_goods_data_2015
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_order_goods_data_2017`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_goods_data_2017`;
CREATE TABLE `es_sss_order_goods_data_2017` (
  `id` int(11) NOT NULL DEFAULT '0',
  `order_sn` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `goods_id` int(10) DEFAULT NULL,
  `goods_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `goods_num` int(10) DEFAULT NULL,
  `price` decimal(20,2) DEFAULT NULL,
  `sub_total` decimal(20,2) DEFAULT NULL,
  `category_path` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `category_id` int(10) DEFAULT '0',
  `create_time` int(12) DEFAULT '0',
  `industry_id` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_order_goods_data_2017
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_order_goods_data_2018`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_goods_data_2018`;
CREATE TABLE `es_sss_order_goods_data_2018` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
  `goods_id` int(10) DEFAULT NULL COMMENT '商品id',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `goods_num` int(10) DEFAULT NULL COMMENT '数量',
  `price` decimal(20,2) DEFAULT NULL COMMENT '商品单价',
  `sub_total` decimal(20,2) DEFAULT NULL COMMENT '小计',
  `category_path` varchar(255) DEFAULT NULL COMMENT '分类path',
  `category_id` int(10) DEFAULT NULL COMMENT '分类id',
  `create_time` int(12) DEFAULT NULL COMMENT '创建时间',
  `industry_id` bigint(10) DEFAULT NULL COMMENT '行业id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of es_sss_order_goods_data_2018
-- ----------------------------
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('1', '20180821000016', '292', '【内蒙古乌兰察布】草原星 内蒙特产牛肉干手撕500g实惠装 香辣味', '1', '0.00', '0.00', '0|1|2|306|', '306', '1534847476', '306');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('2', '20180821000016', '285', '【三只松鼠_碧根果210gx2袋】零食坚果炒货山核桃长寿果干果奶油味 奶油口味', '1', '0.00', '0.00', '0|1|2|6|', '6', '1534847476', '6');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('3', '20180821000016', '184', '罗技（Logitech）G402 高速追踪游戏鼠标 吃鸡鼠标', '1', '173.33', '173.33', '0|491|502|505|', '505', '1534847476', '505');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('4', '20180821000015', '49', '百雀羚小森羚温和净颜卸妆水脸部眼唇卸妆液清洁毛孔不油腻', '1', '1599.00', '1599.00', '0|1|18|21|', '21', '1534847476', '21');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('5', '20180821000015', '51', '佳雪芦荟保湿霜3瓶量贩套装国货护肤品芦荟胶滋润补水面霜', '1', '5999.00', '5999.00', '0|1|18|19|', '19', '1534847476', '19');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('6', '20180821000015', '50', '百雀羚小森羚海棠身体乳润肤乳保湿滋润补水淡香润体乳学生少女', '5', '2999.99', '14999.95', '0|1|18|19|', '19', '1534847476', '19');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('7', '20180821000014', '27', '纺布者潮牌大码卫衣男加肥加大秋季新款男士长袖胖子时尚宽松上衣', '1', '15.90', '15.90', '0|1|2|', '2', '1534847476', '2');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('8', '20180821000013', '173', '未来人类(Terrans Force)S4-1060-67S', '1', '11999.00', '11999.00', '0|491|492|494|', '494', '1534847476', '494');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('9', '20180821000012', '173', '未来人类(Terrans Force)S4-1060-67S', '1', '11997.00', '11997.00', '0|491|492|494|', '494', '1534847342', '494');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('10', '20180821000010', '183', '锤子M1L白色-6G+64GB移动联通电信全网通公开版', '1', '3182.00', '3182.00', '0|491|492|497|', '497', '1534847309', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('11', '20180821000009', '185', '锤子M1-咖啡金-4G+32GB 移动联通电信全网通', '1', '2997.00', '2997.00', '0|491|492|497|', '497', '1534847294', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('12', '20180821000011', '177', 'Apple iPhone 7 Plus 128GB 玫瑰金色', '1', '6486.00', '6486.00', '0|491|492|497|', '497', '1534847327', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('13', '20180821000007', '193', '海尔（Haier）BCD-310WDPF 310升多门冰箱 ', '1', '3697.00', '3697.00', '0|491|493|495|', '495', '1534847262', '495');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('14', '20180821000008', '186', '红米Note 4 高配全网通版 3GB内存 64GB 金色', '1', '1199.00', '1199.00', '0|491|492|497|', '497', '1534847277', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('15', '20180821000001', '107', '儿童电动车摇摆童车四轮室内车带遥控玩具车可坐人摩托车电动汽车', '1', '67.32', '67.32', '0|56|66|69|', '69', '1534846758', '69');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('16', '20180821000002', '303', '戴尔（DELL）灵越 13-7370-R1505S 13.3英寸轻薄笔记本电脑（i5-8250U 8G 128G', '1', '6099.00', '6099.00', '0|491|492|494|', '494', '1534847172', '494');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('17', '20180821000003', '178', 'HUAWEI nova（3GB+32GB）CAZ-TL10 ', '1', '1596.00', '1596.00', '0|491|492|497|', '497', '1534847204', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('18', '20180821000004', '224', '美的（Midea）嵌入式微波炉 TG025QPS-NSH 2', '1', '2299.00', '2299.00', '0|491|500|511|', '511', '1534847216', '511');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('19', '20180821000005', '175', '美的(Midea)WFS3018Q智能可预约电饭煲 3升/3', '1', '189.00', '189.00', '0|491|500|501|', '501', '1534847228', '501');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('20', '20180821000006', '224', '美的（Midea）嵌入式微波炉 TG025QPS-NSH 2', '1', '2299.00', '2299.00', '0|491|500|511|', '511', '1534847240', '511');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('21', '20180821000036', '49', '百雀羚小森羚温和净颜卸妆水脸部眼唇卸妆液清洁毛孔不油腻', '1', '1599.00', '1599.00', '0|1|18|21|', '21', '1534848112', '21');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('22', '20180821000036', '48', '百雀羚三生花舒缓细肤柔润凝乳精华乳液女补水保湿学生', '1', '2599.00', '2599.00', '0|1|18|168|', '168', '1534848112', '168');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('23', '20180821000036', '63', 'LA MER海蓝之谜赋活保湿精华露30ml 水润保湿 润泽', '1', '199.00', '199.00', '0|38|39|385|', '385', '1534848112', '385');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('24', '20180821000036', '65', '兰蔻 黑金臻宠精华乳30ml 柔软平滑紧致光泽 淡细纹补水保湿滋润', '1', '159.90', '159.90', '0|38|39|385|', '385', '1534848112', '385');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('25', '20180821000034', '229', 'Razer雷蛇 黑寡妇蜘蛛V2幻彩版 lol电竞游戏机械键盘', '1', '1079.00', '1079.00', '0|491|502|506|', '506', '1534848112', '506');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('26', '20180821000034', '227', '樱桃（Cherry）机械键盘G80-3000LSCEU-0白', '1', '699.00', '699.00', '0|491|502|506|', '506', '1534848112', '506');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('27', '20180821000035', '302', 'honor荣耀畅玩7X尊享版 4GB+128GB 铂光金 移动联通电信4G手机', '1', '1999.00', '1999.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('28', '20180821000035', '283', '未来人类(Terrans Force) X911-1080S-77X 桌面级i7-7700K 双GTX1080显卡 新', '1', '39888.00', '39888.00', '0|491|492|494|', '494', '1534848112', '494');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('29', '20180821000035', '234', '三星 Galaxy S8 Plus S8+（G9550）6G', '1', '7288.00', '7288.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('30', '20180821000035', '298', 'Apple iPhone 8 Plus 64GB 金色 移动联通电信4G手机', '1', '6688.00', '6688.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('31', '20180821000035', '299', '三星 Galaxy S7 edge（G9350）4+64G版 铂光金 全网通', '1', '3299.00', '3299.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('32', '20180821000035', '226', 'OPPO R11 Plus 6GB+64GB 玫瑰金', '1', '3699.00', '3699.00', '0|491|492|497|', '497', '1534848112', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('33', '20180821000033', '234', '三星 Galaxy S8 Plus S8+（G9550）6G', '1', '7288.00', '7288.00', '0|491|492|497|', '497', '1534847978', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('34', '20180821000033', '236', ' 三星手机SM-W2017', '1', '12049.00', '12049.00', '0|491|492|497|', '497', '1534847978', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('35', '20180821000032', '238', '小米路由器3G 双千兆光纤宽带穿墙王 高增益四天线 散热好 ', '1', '249.00', '249.00', '0|491|502|508|', '508', '1534847964', '508');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('36', '20180821000031', '232', ' 小米6 全网通 6GB+128GB 探索银限量版', '1', '4799.00', '4799.00', '0|491|492|497|', '497', '1534847947', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('37', '20180821000030', '229', 'Razer雷蛇 黑寡妇蜘蛛V2幻彩版 lol电竞游戏机械键盘', '1', '1079.00', '1079.00', '0|491|502|506|', '506', '1534847947', '506');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('38', '20180821000030', '227', '樱桃（Cherry）机械键盘G80-3000LSCEU-0白', '1', '699.00', '699.00', '0|491|502|506|', '506', '1534847947', '506');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('39', '20180821000028', '226', 'OPPO R11 Plus 6GB+64GB 玫瑰金', '1', '3699.00', '3699.00', '0|491|492|497|', '497', '1534847900', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('40', '20180821000025', '203', '小米（MI）米家IH电饭煲 智能电饭煲 IH电磁环绕加热 手', '1', '399.00', '399.00', '0|491|500|501|', '501', '1534847855', '501');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('41', '20180821000021', '48', '百雀羚三生花舒缓细肤柔润凝乳精华乳液女补水保湿学生', '1', '2599.00', '2599.00', '0|1|18|168|', '168', '1534847789', '168');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('42', '20180821000027', '211', '三洋（SANYO）WF810326BS0S 8公斤', '1', '1738.00', '1738.00', '0|491|493|498|', '498', '1534847888', '498');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('43', '20180821000029', '230', '小米（MI）小米便携鼠标 智能轻薄便携 无线+蓝牙双连接 家', '1', '120.00', '120.00', '0|491|502|505|', '505', '1534847921', '505');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('44', '20180821000024', '200', '创维(Skyworth) 55M7 55英寸', '1', '2799.00', '2799.00', '0|491|493|496|', '496', '1534847855', '496');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('45', '20180821000024', '199', 'TCL D55A620U 55英寸 观影王4K版', '1', '3999.00', '3999.00', '0|491|493|496|', '496', '1534847855', '496');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('46', '20180821000022', '48', '百雀羚三生花舒缓细肤柔润凝乳精华乳液女补水保湿学生', '1', '2599.00', '2599.00', '0|1|18|168|', '168', '1534847803', '168');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('47', '20180821000022', '49', '百雀羚小森羚温和净颜卸妆水脸部眼唇卸妆液清洁毛孔不油腻', '1', '1599.00', '1599.00', '0|1|18|21|', '21', '1534847803', '21');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('48', '20180821000023', '203', '小米（MI）米家IH电饭煲 智能电饭煲 IH电磁环绕加热 手', '1', '399.00', '399.00', '0|491|500|501|', '501', '1534847828', '501');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('49', '20180821000020', '195', '华硕（ASUS）Spatha ROG玩家国度 游戏鼠标', '1', '1299.00', '1299.00', '0|491|502|505|', '505', '1534847756', '505');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('50', '20180821000019', '193', '海尔（Haier）BCD-310WDPF 310升多门冰箱 ', '1', '3699.00', '3699.00', '0|491|493|495|', '495', '1534847748', '495');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('51', '20180821000026', '209', '索尼(SONY)KDL-48W650D 48英寸 全高清LE', '1', '3199.00', '3199.00', '0|491|493|496|', '496', '1534847874', '496');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('52', '20180821000026', '208', '索尼(SONY)KD-55X8500D 55英寸 ', '1', '6999.00', '6999.00', '0|491|493|496|', '496', '1534847874', '496');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('53', '20180821000018', '197', '美菱(MELING) BCD-551WPCX 551升', '1', '2999.00', '2999.00', '0|491|493|495|', '495', '1534847740', '495');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('54', '20180821000017', '191', '魅族 魅蓝note5 4G+全网通版 灰色 移动联通电信4G', '1', '1049.00', '1049.00', '0|491|492|497|', '497', '1534847724', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('55', '20180821000048', '173', '未来人类(Terrans Force)S4-1060-67S', '1', '11999.00', '11999.00', '0|491|492|494|', '494', '1534849489', '494');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('56', '20180821000048', '174', 'Apple iPhone 7 Plus 128GB 亮黑色 ', '1', '6448.00', '6448.00', '0|491|492|497|', '497', '1534849489', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('57', '20180821000047', '65', '兰蔻 黑金臻宠精华乳30ml 柔软平滑紧致光泽 淡细纹补水保湿滋润', '1', '159.90', '159.90', '0|38|39|385|', '385', '1534849447', '385');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('58', '20180821000046', '172', '联想（Lenovo）Y50p-70 15.6英寸游戏笔记本', '1', '6184.00', '6184.00', '0|491|492|494|', '494', '1534849419', '494');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('59', '20180821000045', '63', 'LA MER海蓝之谜赋活保湿精华露30ml 水润保湿 润泽', '1', '199.00', '199.00', '0|38|39|385|', '385', '1534849355', '385');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('60', '20180821000044', '35', '唐狮秋冬季情侣装毛衣男女韩版图案小清新圆领套头学生针织衫', '1', '239.90', '239.90', '0|79|', '79', '1534848960', '79');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('61', '20180821000043', '121', '童装男童秋冬装套装2018新款儿童加绒加厚金丝绒卫衣三件套中大童', '1', '996.00', '996.00', '0|56|200|205|', '205', '1534848845', '205');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('62', '20180821000042', '111', '亿宝莱高景观婴儿推车可坐可躺轻便携式折叠小孩宝宝双向婴儿童车', '1', '59.80', '59.80', '0|56|71|73|', '73', '1534848821', '73');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('63', '20180821000041', '109', '大型儿童电动车四轮卡丁车小孩玩具汽车宝宝遥控可坐人童车', '1', '135.00', '135.00', '0|56|66|426|', '426', '1534848808', '426');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('64', '20180821000040', '110', '米兔故事机mini儿童早教机宝宝婴儿幼儿玩具学习机', '1', '198.00', '198.00', '0|56|71|72|', '72', '1534848801', '72');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('65', '20180821000039', '104', '双鹰遥控搅拌车工程车电动玩具水泥车混凝土罐车汽车模型儿童男孩', '1', '58.90', '58.90', '0|56|62|64|', '64', '1534848794', '64');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('66', '20180821000038', '22', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '1', '25.99', '25.99', '0|56|57|', '57', '1534848783', '57');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('67', '20180821000037', '101', '亲子装2017新款秋冬季母女装针织衫韩版宽松外穿毛衣纯色打底春装', '1', '385.00', '385.00', '0|56|57|58|', '58', '1534848757', '58');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('68', '20180821000054', '269', '索尼（SONY）PlayStation4游戏手柄 新款PS4无线控制器（蓝色）', '10', '380.00', '3800.00', '0|491|503|521|', '521', '1534849789', '521');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('69', '20180821000054', '273', '索尼（SONY）PS4 Slim Pro 正版游戏软件 实体光盘 GTA5 猎车手5', '1', '222.00', '222.00', '0|491|503|522|', '522', '1534849789', '522');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('70', '20180821000053', '268', '微软（Microsoft) Xbox 无线控制器 （蓝牙连接 带3.5mm的耳机接头 白色）', '1', '429.00', '429.00', '0|491|503|521|', '521', '1534849757', '521');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('71', '20180821000052', '265', '索尼（SONY）【PS4 官方配件】PS4 slim /PSV/PS4 Pro7.1声道 白金版无线头戴耳机', '3', '1299.00', '3897.00', '0|491|503|520|', '520', '1534849750', '520');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('72', '20180821000050', '260', '任天堂 Nintendo switch掌上游戏机便携式掌机Switch NS主机（红蓝手柄）+塞尔达', '5', '3128.00', '15640.00', '0|491|503|519|', '519', '1534849732', '519');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('73', '20180821000049', '258', 'Xbox One S 1TB双手柄竞技版 含体感器及三国志、最终幻想等11款游戏', '1', '4788.00', '4788.00', '0|491|503|519|', '519', '1534849722', '519');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('74', '20180821000051', '261', '索尼 Sony PlayStation 4 PS4 Pro 国行游戏主机 HDR色彩 支持4K 1TB容量 黑色', '5', '3299.00', '16495.00', '0|491|503|519|', '519', '1534849741', '519');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('75', '20180821000055', '35', '唐狮秋冬季情侣装毛衣男女韩版图案小清新圆领套头学生针织衫', '2', '259.90', '519.80', '0|79|', '79', '1534854174', '79');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('76', '20180821000060', '22', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '1', '25.99', '25.99', '0|56|57|', '57', '1534855395', '57');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('77', '20180821000061', '22', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '1', '25.99', '25.99', '0|56|57|', '57', '1534855489', '57');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('78', '20180821000062', '22', '情侣装冬装2017新款秋冬季韩版中长款修身呢子大衣女加厚毛呢外套', '3', '25.99', '77.97', '0|56|57|', '57', '1534855641', '57');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('79', '20180821000063', '173', '未来人类(Terrans Force)S4-1060-67S', '1', '11999.00', '11999.00', '0|491|492|494|', '494', '1534855784', '494');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('80', '20180821000064', '27', '纺布者潮牌大码卫衣男加肥加大秋季新款男士长袖胖子时尚宽松上衣', '2', '15.90', '31.80', '0|1|2|', '2', '1534855837', '2');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('81', '20180821000130', '331', '东道 汝窑坐禅茶组 汝窑茶具套装开片汝瓷功夫整套茶具 坐禅小茶组一壶三杯-天青', '2', '20.00', '40.00', '0|79|130|131|', '131', '1534860136', '131');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('82', '20180821000130', '333', '张小泉 (Zhang Xiao Quan) NS-7 合金指甲剪修甲剪刀脚趾剪子', '2', '12.00', '24.00', '0|79|219|221|', '221', '1534860136', '221');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('83', '20180821000130', '334', 'LANCOME 兰蔻清滢保湿柔肤水大粉水400ml爽肤水女补水保湿补水滋润营养正品大瓶装 法国进口【最新版本】', '1', '309.00', '309.00', '0|38|39|383|', '383', '1534860136', '383');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('84', '20180821000130', '329', '富光（FUGUANG) 玻璃杯WFB1020-500 500ml男女士带茶隔 便携创意双层泡茶玻璃水杯 500ml', '1', '10.00', '10.00', '0|79|124|125|', '125', '1534860136', '125');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('85', '20180821000130', '330', '乐扣乐扣（lock&lock）塑料杯 杯子水杯 随手杯 470ML HPL931', '1', '11.90', '11.90', '0|79|124|126|', '126', '1534860136', '126');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('86', '20180821000130', '328', '苏泊尔（SUPOR）炒锅NC32F4易洁不粘锅 32cm 少油烟 送原装木铲', '1', '169.00', '169.00', '0|79|80|83|', '83', '1534860136', '83');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('87', '20180821000130', '326', '美的（Midea）电水壶 WSJ1702b 1.7L 优质温控器 食品级304不锈钢 电热水瓶 电热水壶 电水壶', '1', '79.00', '79.00', '0|79|80|82|', '82', '1534860136', '82');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('88', '20180823000001', '259', 'honor荣耀V9 play标配版 3GB+32GB 幻夜黑', '1', '999.00', '999.00', '0|491|492|497|', '497', '1535004810', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('89', '20180823000002', '259', 'honor荣耀V9 play标配版 3GB+32GB 幻夜黑', '1', '999.00', '999.00', '0|491|492|497|', '497', '1535005346', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('90', '20180823000003', '321', '促销商品J', '1', '50.00', '50.00', '0|1|2|7|', '7', '1535005785', '7');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('91', '20180823000115', '1', '百草味菠萝干100g 菠萝块凤梨干/片蜜饯水果干小吃', '6', '25.90', '155.40', '0|1|13|14|', '14', '1535033977', '14');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('92', '20180823000115', '315', '促销商品D', '1', '35.00', '35.00', '0|1|2|7|', '7', '1535033977', '7');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('93', '20180827000002', '269', '索尼（SONY）PlayStation4游戏手柄 新款PS4无线控制器（蓝色）', '1', '380.00', '380.00', '0|491|503|521|', '521', '1535341105', '521');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('94', '20180830000002', '264', 'vivo X20 4GB+64GB 磨砂黑 移动联通电信4G手机 全面屏拍照 面部识别', '1', '2998.00', '2998.00', '0|491|492|497|', '497', '1535593961', '497');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('95', '20180830000001', '260', '任天堂 Nintendo switch掌上游戏机便携式掌机Switch NS主机（红蓝手柄）+塞尔达', '1', '3128.00', '3128.00', '0|491|503|519|', '519', '1535593896', '519');
INSERT INTO `es_sss_order_goods_data_2018` VALUES ('96', '20180830000003', '209', '索尼(SONY)KDL-48W650D 48英寸 全高清LE', '1', '3199.00', '3199.00', '0|491|493|496|', '496', '1535611803', '496');

-- ----------------------------
-- Table structure for `es_sss_order_goods_data_2019`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_order_goods_data_2019`;
CREATE TABLE `es_sss_order_goods_data_2019` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) DEFAULT NULL,
  `goods_id` int(10) DEFAULT NULL,
  `goods_name` varchar(255) DEFAULT NULL,
  `goods_num` int(10) DEFAULT NULL,
  `price` decimal(20,2) DEFAULT NULL,
  `sub_total` decimal(20,2) DEFAULT NULL,
  `category_path` varchar(255) DEFAULT NULL,
  `category_id` int(10) DEFAULT '0',
  `create_time` int(12) DEFAULT '0',
  `industry_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=206 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `es_sss_refund_data`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_refund_data`;
CREATE TABLE `es_sss_refund_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `seller_id` int(10) DEFAULT NULL COMMENT '商家id',
  `order_sn` varchar(255) DEFAULT NULL COMMENT '订单sn',
  `refund_sn` varchar(255) DEFAULT NULL COMMENT '售后订单sn',
  `refund_price` decimal(20,2) DEFAULT NULL COMMENT '退还金额',
  `create_time` int(12) DEFAULT NULL COMMENT '创建日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='退货数据(es_sss_refund_data)';

-- ----------------------------
-- Records of es_sss_refund_data
-- ----------------------------
INSERT INTO `es_sss_refund_data` VALUES ('1', '18', '180830025128', '20180830000003', '3199.00', '1535611888');
INSERT INTO `es_sss_refund_data` VALUES ('2', '18', '180830024026', '20180830000002', '2998.00', '1535611226');

-- ----------------------------
-- Table structure for `es_sss_refund_data_2015`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_refund_data_2015`;
CREATE TABLE `es_sss_refund_data_2015` (
  `id` int(10) NOT NULL DEFAULT '0',
  `seller_id` int(10) DEFAULT NULL,
  `refund_sn` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `order_sn` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `refund_price` decimal(20,2) DEFAULT NULL,
  `create_time` int(12) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_refund_data_2015
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_refund_data_2017`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_refund_data_2017`;
CREATE TABLE `es_sss_refund_data_2017` (
  `id` int(10) NOT NULL DEFAULT '0',
  `seller_id` int(10) DEFAULT NULL,
  `refund_sn` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `order_sn` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `refund_price` decimal(20,2) DEFAULT NULL,
  `create_time` int(12) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_refund_data_2017
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_refund_data_2018`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_refund_data_2018`;
CREATE TABLE `es_sss_refund_data_2018` (
  `id` int(10) NOT NULL DEFAULT '0',
  `seller_id` int(10) DEFAULT NULL,
  `refund_sn` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `order_sn` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `refund_price` decimal(20,2) DEFAULT NULL,
  `create_time` int(12) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_refund_data_2018
-- ----------------------------
INSERT INTO `es_sss_refund_data_2018` VALUES ('1', '18', '180830025128', '20180830000003', '3199.00', '1535611888');
INSERT INTO `es_sss_refund_data_2018` VALUES ('2', '18', '180830024026', '20180830000002', '2998.00', '1535611226');

-- ----------------------------
-- Table structure for `es_sss_refund_data_2019`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_refund_data_2019`;
CREATE TABLE `es_sss_refund_data_2019` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) DEFAULT NULL,
  `refund_sn` varchar(255) DEFAULT NULL,
  `order_sn` varchar(255) DEFAULT NULL,
  `refund_price` decimal(20,2) DEFAULT NULL,
  `create_time` int(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `es_sss_shop_data`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_shop_data`;
CREATE TABLE `es_sss_shop_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `seller_id` int(10) DEFAULT NULL COMMENT '店铺id',
  `seller_name` varchar(255) DEFAULT NULL COMMENT '店铺名称',
  `favorite_num` int(255) DEFAULT NULL COMMENT '店铺被收藏数量',
  `shop_disable` varchar(50) DEFAULT NULL COMMENT '店铺是否开启',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='商品数据表(es_sss_shop_data)';

-- ----------------------------
-- Records of es_sss_shop_data
-- ----------------------------
INSERT INTO `es_sss_shop_data` VALUES ('10', '1', '平台自营', '1', 'OPEN');
INSERT INTO `es_sss_shop_data` VALUES ('11', '5', '时尚女装/搭配', '0', 'OPEN');
INSERT INTO `es_sss_shop_data` VALUES ('12', '10', '母婴和玩具', '0', 'OPEN');
INSERT INTO `es_sss_shop_data` VALUES ('13', '15', '食品酒水', '0', 'OPEN');
INSERT INTO `es_sss_shop_data` VALUES ('14', '16', 'superman', '1', 'OPEN');
INSERT INTO `es_sss_shop_data` VALUES ('15', '17', '化妆品店铺', '0', 'OPEN');
INSERT INTO `es_sss_shop_data` VALUES ('16', '18', '数码家电', '0', 'OPEN');

-- ----------------------------
-- Table structure for `es_sss_shop_pv`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_shop_pv`;
CREATE TABLE `es_sss_shop_pv` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `seller_id` int(10) DEFAULT NULL COMMENT '店铺id',
  `vs_year` int(4) DEFAULT NULL COMMENT '年份',
  `vs_month` int(4) DEFAULT NULL COMMENT '月份',
  `vs_day` int(4) DEFAULT NULL COMMENT '日期',
  `vs_num` int(10) DEFAULT NULL COMMENT '访问量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8 COMMENT='店铺访问量统计表(es_sss_shop_pv)';

-- ----------------------------
-- Records of es_sss_shop_pv
-- ----------------------------
INSERT INTO `es_sss_shop_pv` VALUES ('1', '2', '2018', '8', '23', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('4', '3', '2018', '8', '23', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('9', '1', '2018', '8', '23', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('19', '9', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('23', '13', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('31', '4', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('33', '2', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('38', '1', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('40', '10', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('43', '13', '2018', '8', '27', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('45', '1', '2018', '8', '27', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('46', '2', '2018', '8', '27', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('62', '2', '2018', '8', '28', '1');
INSERT INTO `es_sss_shop_pv` VALUES ('70', '1', '2018', '8', '31', '1');

-- ----------------------------
-- Table structure for `es_sss_shop_pv_2015`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_shop_pv_2015`;
CREATE TABLE `es_sss_shop_pv_2015` (
  `id` int(10) NOT NULL,
  `seller_id` int(10) DEFAULT NULL,
  `vs_year` int(4) DEFAULT NULL,
  `vs_month` int(4) DEFAULT NULL,
  `vs_day` int(4) DEFAULT NULL,
  `vs_num` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_shop_pv_2015
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_shop_pv_2017`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_shop_pv_2017`;
CREATE TABLE `es_sss_shop_pv_2017` (
  `id` int(10) NOT NULL,
  `seller_id` int(10) DEFAULT NULL,
  `vs_year` int(4) DEFAULT NULL,
  `vs_month` int(4) DEFAULT NULL,
  `vs_day` int(4) DEFAULT NULL,
  `vs_num` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_shop_pv_2017
-- ----------------------------

-- ----------------------------
-- Table structure for `es_sss_shop_pv_2018`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_shop_pv_2018`;
CREATE TABLE `es_sss_shop_pv_2018` (
  `id` int(10) NOT NULL DEFAULT '0',
  `seller_id` int(10) DEFAULT NULL,
  `vs_year` int(4) DEFAULT NULL,
  `vs_month` int(4) DEFAULT NULL,
  `vs_day` int(4) DEFAULT NULL,
  `vs_num` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of es_sss_shop_pv_2018
-- ----------------------------
INSERT INTO `es_sss_shop_pv_2018` VALUES ('1', '2', '2018', '8', '23', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('4', '3', '2018', '8', '23', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('9', '1', '2018', '8', '23', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('19', '9', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('23', '13', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('31', '4', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('33', '2', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('38', '1', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('40', '10', '2018', '8', '24', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('43', '13', '2018', '8', '27', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('45', '1', '2018', '8', '27', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('46', '2', '2018', '8', '27', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('62', '2', '2018', '8', '28', '1');
INSERT INTO `es_sss_shop_pv_2018` VALUES ('70', '1', '2018', '8', '31', '1');

-- ----------------------------
-- Table structure for `es_sss_shop_pv_2019`
-- ----------------------------
DROP TABLE IF EXISTS `es_sss_shop_pv_2019`;
CREATE TABLE `es_sss_shop_pv_2019` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seller_id` int(10) DEFAULT NULL,
  `vs_year` int(4) DEFAULT NULL,
  `vs_month` int(4) DEFAULT NULL,
  `vs_day` int(4) DEFAULT NULL,
  `vs_num` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=174 DEFAULT CHARSET=utf8;

-- 如果已经按照文档更改了数据库字符集，请将下面注释的的脚本在相应的库中执行
-- alter table es_sss_goods_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_goods_pv CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_goods_pv_2015 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_goods_pv_2017 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_goods_pv_2018 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_member_register_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_order_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_order_data_2015 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_order_data_2017 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_order_data_2018 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_order_goods_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_order_goods_data_2015 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_order_goods_data_2017 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_order_goods_data_2018 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_refund_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_refund_data_2015 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_refund_data_2017 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_refund_data_2018 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_shop_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_shop_pv CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_shop_pv_2015 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_shop_pv_2017 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sss_shop_pv_2018 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;